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.
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.
Step by step
Solved in 2 steps
