Question

Write a query to display the sales id, IME number and sales date of mobiles only for the month of February 2012. Sort the records based on sales id.

Answer 1

Answer:

Explanation:

 

 

MOBILE MANAGEMENT SYSTEM1. Write a Query to Display the IME Number, Model Name of mobiles which is manufactured by"Nokia".

Select IME_No,Model_Name from mobile_master where Manufacturer="Nokia";

2. Write a Query to display IME number, Model Name, Manufacturer and Camera Quality ofmobiles whose camera quality is 5MP.

select m.IME_No,m.Model_Name,m.Manufacturer,s.Camera_Quality from mobile_masterm,mobile_specification s where m.IME_No=s.IME_no and s.Camera_Quality="5MP";

3. "Write a Query to display the Mobile Model Name and respective number of mobiles sold onthe date 23-Apr-2012 for each mobile model.<br/> Hint: For example, if 2 ""Nokia 1100"" and 1 ""Nokia C5-03"" are sold on the date 23-Apr-2012then display both the records. Use ""NoofMobilesSold"" as alias name for the number of mobilesfield."

Select m.Model_Name,count(m.Model_Name) as Noofmobilessold from mobile_master m,sales_info swhere m.IME_No=s.IME_No and s.Sales_Date="2012-4-23" group by m.Model_Name;

4. "Write a Query to display the distributor id, mobile model name, number of mobiles of theparticular model name supplied to the distributors group by model name and distributor id and sortby the distributor id.<br/> Hint: For example, if 3 ""Nokia 1100"" and 1 ""Nokia C5-03"" are sold to one distributor thendisplay both the records. <br/>Display the distributor id, model name and number of mobiles of aparticular model name. <br/>Use ""NoofMobilesSupplied"" as alias name for the number of mobiles."

Select d.Distributor_ID,m.Model_Name,count(m.Model_Name) as Noofmobilessupplied fromdistributor d, mobile_master m where d.Distributor_ID=m.Distributor_ID group by m.Model_Nameorder by d.Distributor_ID;

5. "Write a Query to display the IME number, model name, manufacturer, price and discount of allmobiles regardless of whether the mobile is sold or not. <br/> Hint: Fetch the price, IME no and modelname from mobile_master table. <br/>Example: For the mobile model ""Samsung GalaxyTAB with IME NO ""MC1000103"" is sold and otherwith IME No ""MC1000110"" is not sold. <br/>Then both the mobiles details namely IME number,model name, manufacturer, price and discount needs to be displayed.

Answer 2

Answer:

select salesid,ime_no, sales_date from sales_info where sales_date like '%-FEB-12' order by salesid;

Explanation: