View the Exhibit and examine the structure of the PRODUCTS tables. You want to generate a report that displays the average list price of product categories where the average list price is less than half the maximum in each category.…

View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement: SQL>SELECT promo_name,CASE WHEN promo_cost >=(SELECT AVG(promo_cost) FROM promotions WHERE promo_category=’TV’) then ‘HIGH’ else ‘LOW’ END COST_REMARK FROM promotions; Which statement is true regarding the…

Evaluate the following SQL statement: SQL> SELECT cust_id, cust_last_name FROM customers WHERE cust_credit_limit IN (select cust_credit_limit FROM customers WHERE cust_city =’Singapore’); Which statement is true regarding the above query if one of the values generated by the subquery is NULL?…

View the Exhibit and examine the structure of the PRODUCTS table. You want to display the category with the maximum number of items. You issue the following query: SQL>SELECT COUNT(*),prod_category_id FROM products GROUP BY prod_category_id HAVING COUNT(*) = (SELECT MAX(COUNT(*))…

Examine the structure of the PRODUCTS table: You want to display the names of the products that have the highest total value for UNIT_PRICE *QTY_IN_HAND. Which SQL statement gives the required output? A. SELECT prod_nameFROM productsWHERE (unit_price * qty_in_hand) =…

View the Exhibits and examine PRODUCTS and SALES tables. You issue the following query to display product name and the number of times the product has been sold: SQL>SELECT p.prod_name, i.item_cnt FROM (SELECT prod_id, COUNT(*) item_cnt FROM sales GROUP BY…

View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks would require subqueries? (Choose two.) A. Display the minimum list price for each product status. B. Display all suppliers whose list price is less than 1000.…

Which three statements are true regarding subqueries? (Choose three.) A. Subqueries can contain GROUP BY and ORDER BY clauses. B. Main query and subquery can get data from different tables. C. Main query and subquery must get data from the…

Which two statements are true regarding subqueries? (Choose two.) A. A subquery can retrieve zero or more rows. B. Only two subqueries can be placed at one level. C. A subquery can be used only in SQL query statements. D.…

View the Exhibit and examine the structure of the SALES and PRODUCTS tables. In the SALES table, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table. You want to list each product ID and the number of times…