1. Write an SQL query to display Product ID, name and product date for the products that have been manufactured before ‘07/01/2020’. 2. Write an SQL query to display Product ID and name for the...


1.     Write an SQL query to display Product ID, name and product date for the products that have been manufactured before ‘07/01/2020’.


2.     Write an SQL query to display Product ID  and name for the product ID that begins with 2 and having Quantity 5.


3.     Write an SQL query to display the product name , date and quantity for the products whose quantity is in the range of 5 to 6.


4.     Write an SQL query to display all the details of the products whose unit price is less than or equal to 3.5 . Sort your query result in the descending order of the quantity.



Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here