3.1. As a sales agent, you have been tasked to write SQL query that searches the STOCKLIST_INFORMATION database for STOCK_ NAME values beginning with LP (LAPTOP) or CPU and their list prices. Remember that the laptop list price must be between R6000 and R9000, and the CPU speed must be either 5x2ghz or 5x3ghz. Sort the results in descending ITEM_PRICE order. 3.2. A political party agreed to present a handbag to every member of the party's women's league. Most of them want pink handbag. Several price quotes for pink purses were requested. The supplier information is not available from the normal source, but you know that the supplier identification number is embedded in the STOCK_ INFORMATION table's CATALOG URL field. You must get the STOCK_NAME and CATALOG URL values, as well as the supplier number from the CATALOG URL column, for all goods that have both the words PINK and HANDBAG contained in the STOCK_DESCRIPTION column. Hint: A typical CATALOG_URL entry looks as follows: www.supp102094.com/cat/hw/p1797.html. The supplier identification number is consistently six characters long and starts from the seventeenth character of the CATALOG_URL value. 3.1. You are required to obtain from PRODCT table a list of PRODUCT_ID, PRODUCT_NAME, and PURCHASE_DATE values for the goods that have been bought over 36 months between the purchase date and 01-MAR-2022.
3.1. As a sales agent, you have been tasked to write SQL query that searches the STOCKLIST_INFORMATION
3.2. A political party agreed to present a handbag to every member of the party's women's league. Most of them want pink handbag. Several price quotes for pink purses were requested. The supplier information is not available from the normal source, but you know that the supplier identification number is embedded in the STOCK_ INFORMATION table's CATALOG URL field. You must get the STOCK_NAME and CATALOG URL values, as well as the supplier number from the CATALOG URL column, for all goods that have both the words PINK and HANDBAG contained in the STOCK_DESCRIPTION column. Hint: A typical CATALOG_URL entry looks as follows: www.supp102094.com/cat/hw/p1797.html. The supplier identification number is consistently six characters long and starts from the seventeenth character of the CATALOG_URL value.
3.1. You are required to obtain from PRODCT table a list of PRODUCT_ID, PRODUCT_NAME, and PURCHASE_DATE values for the goods that have been bought over 36 months between the purchase date and 01-MAR-2022.
Step by step
Solved in 7 steps with 3 images
