Scribd
Upload
2 views6 pages

MySQL Database Query Techniques

The document outlines various MySQL queries to manipulate and display data from a product database. It includes tasks such as joining product and company tables, converting product names to uppercase, calculating quantities and prices, and displaying unique products and companies. The queries also involve aggregating data to find maximum, minimum, and average prices for specific product categories.

Uploaded by

adityakca08
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views6 pages

MySQL Database Query Techniques

The document outlines various MySQL queries to manipulate and display data from a product database. It includes tasks such as joining product and company tables, converting product names to uppercase, calculating quantities and prices, and displaying unique products and companies. The queries also involve aggregating data to find maximum, minimum, and average prices for specific product categories.

Uploaded by

adityakca08
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Part 3: Database Query

using MySQL
12. To join product and company and display in the tabular form like – <pname>
manufactured by <company>
Convert all product name into capital

Display the cube of products quantity for more than or 100 in quantity.

Di
vide the price by 3 and display the result with 1 fraction digit for the price of more than
40,000.

Display pname (last four letters only), qty, price with 2 decimal points and company for price
in between 30000 to 80000.
Display maximum price of products

Display the total quantities of all products

Display the average price of LED TV and Apple products

Find the difference between maximum price and minimum price from the table.
Display unique Products from the table.

Count the unique company from products.

Display the product number, product name and company in the descending order of their
price.
Display product minimum price for each company.

Display product number and product names in their ascending order of names.

Display maximum price of products manufactured by apple.

You might also like