SQL Challenge 1

Can Anyone Solve it ?


                                              Refer the below E-R diagram: 

  1. Write a query to display the name of the company that manufactures the most number of medications. In case of multiple records, display the records sorted in ascending order based on company name.     

  2. Write a query to display the name of the company and its contact number. Display the contact number in the following format -> +91cccc. For example , +91-994-432-3456. If the contact number is NULL, display as 'N/A'. Give an alias to the contact number as Contact_Number. Display the records sorted in ascending order based on company name.                                                                  
  3. Write a query to display the names of medications manufactured by the company that manufactures the most number of medications. Display the records sorted in ascending order based on medication name.                                                                                                                                   
  4. Write a query to display the company name and the number of medications manufactured by that company. Give an alias to the number of medications as medication_count. Include only pharmaceutical companies that have manufactured atleast 1 medication. Display the records sorted in ascending order based on company name.  



Post Author

Unknown

We share resources which would help recover your mobiles, computers and also update new information about latest information and launches of products making you up to date.

No comments :

Post a Comment