Mobile Brand Analysis.sql

CREATE schema mobdata;
use mobdata;
select * from mobile;
-- Check mobile feature and price list --
select phone_name, price from mobile;

-- Find out the price of 5 most expensive phone --
select * from mobile
order by price desc
limit 5;

-- Find out the price of 5 most cheapest phones--
select * from mobile
order by price asc
limit 5;

-- List of top 5 Samsung phone with price and all feature -- 
select * from mobile where brands = "Samsung"
order by price desc
limit 5;

-- Must have android phone list then top 5 high price android phones --
select * from mobile where operating_system_type = "Android"
order by price desc
limit 5;

-- Must have android phone list than top 5 lower price android phones --
select * from mobile where operating_system_type = "Android"
order by price asc
limit 5; 

-- Must have IOS phone list then top 5 High price IOS phones --
select * from mobile where operating_system_type = "IOS"
order by price desc
limit 5;

-- Must have IOS phone list then top 5 lower price IOS phones --
select * from mobile where operating_system_type = "IOS"
order by price asc
limit 5;

-- Write query which phone support 5g and also top 5 phone with 5g support -- 
select * from mobile where 5g_availability = "Yes"
order by price desc
limit 5;

-- Total price of all mobile is to be found with brand name --
select brands,sum(price) from mobile group by brands;