Examine the structure of the PROMOTIONS table below. Evaluate the following two SQL statements: 

>SELECT promo_category, SUM (promo_cost) FROM promotions WHERE promo_end_date-promo_begin_date > 30 GROUP BY promo_category; 

>SELECT promo_category, sum (promo_cost) FROM promotions GROUP BY promo_category HAVING MIN (promo_end_date-promo_begin_date) > 30; 

Which of the following statements is true about the above two SQL statements?

Examine the description for the PRODUCTS and SALES table in the Exhibit below. 

PROD_ID is a primary key in the PRODUCTS table as well as a foreign key in the SALES table. 

In order to remove from the PRODUCTS table all those rows with no sales done within the last three years, which DELETE statement would you use?

Which of the following statements is true in regards of the INTERSECT operator?

Examine the structure of the CUSTOMERS table in the following Exhibit. Analyze the query below: 

> SELECT cust_last_name, cust_city, cust_credit_limit FROM customers WHERE cust_last_name BETWEEN ‘A’ AND ‘C’ AND cust_credit_limit BETWEEN 1000 AND 3000; 

What would be the result of executing the above statement?

In order to store details for an order that have been placed, you have to create an ORD_DETAIL table with the following business requirements: 

1) The order ID must be unique and cannot contain null values. 

2) The order date column cannot contain null values; if no date is entered, current date will be set by default. 

3) The minimum order amount should be 50. 

4) Values for the order status will be set as shipped or not shipped. 

5) Cheque, credit card, or cash on delivery (COD) should be the options for the order payment mode. Which of the following DDL statements would create the ORD_DETAIL table meeting all requirements?

Examine the structure of the PROMOTIONS, SALES, and CUSTOMER tables in the following Exhibit. For those products that were sold during their promo campaign and before 30th November 2017, you must generate a report which shows the promo name along with the customer name. 

The following query is issued: 

> SELECT promo_name, cust_name FROM promotions p JOIN sales s ON (time_id BETWEEN promo_begin_date AND promo_end_date) JOIN customer c ON (s.cust_id = c.cust_id) AND time_id < ’30-nov-2017’; 

Which of the following statements is true in regards of the above query?

Which action can be performed by using the TO_DATE function?

Analyze the structure of the INVOICE table below: 

Which of the following SQL statements would execute successfully? (Select two.)