Using SQL command to complete the following tasks: Which commands would be used to accomplish these
Question:
Using SQL command to complete the following tasks:
Which commands would be used to accomplish these tasks?
1. Select the supplier number and name from SUPPLIER table.
2. View the different/distinct SUPNR from PURCHASE_ORDER table.
3. In Supplies table, show supplier number, product number and delivery period in weeks. (Note, currently the delivery period unit is day)
4. Find the product number and name of all products staring with the string 'Me' as the start of their product names.
5. View SUPNR, PONR, PODATE from PURCHASE_ORDER table and order the retrieved records in ascending order on PONR field.
6. Insert a new product record with number of '1002', name of 'Leeuwin Estate Cabernet Sauvignon 2011', type of 'white', and quantity of 20.
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last