Assuming that the table AIRPLANES already exists, which of the SQL statements correctly removes all records with manufacturer WRIGHT and model X-WING

Given the following two tables TABLEA and TABLEB with FKAB as foreign key.  Which of the following SQL choices produces this result table: T1.pkA T1.attra1 T2.pkB T2.attrB1 T2.fkAB 1 A1 A B1 1 1 A1 B B2 1 2 A1 D NULL 2 3 A2 NULL NULL NULL 4 A2 NULL NULL NULL 5 NULL F B3 5 NULL NULL C B1 NULL NULL NULL E B2 NULL

EMPLOYEE TABLE empID last_name first_name salary deptID City State 1001 Smith John 61000 500 Fairfax VA 1002 Anderson Jane 57500 500 Fairfax VA 1003 Everest Brad   501 Fairfax VA 1004 Horvath Jack 49000 501 Vienna VA 1005 Smith Maggie 61000 500 Bethesda MD 1006 Lee Jamie   500 Silver Spring MD 1007 Stiles Robert 61000 501 Bethesda AR 1008 Gill Sammy 49000 501 Baltimore MD What would be the result of the following SQL? SELECT COUNT(*) AS A        , COUNT(E.Salary) AS B        , COUNT(DISTINCT E.Salary) AS C FROM EMPLOYEE E

  Write the SQL query to show: Category  of products, total $ sold, and total number of customers sold to. Retrict to include only products with brand containing elec , orders with qtyOrdered of at least 10, with total of quantity ordered exceeding 5000 and number of orders and number of customers of at least 50. NOTE: Each order is uniquely identified using orderNumber Each customer is uniquely identified using AcctNum Total Quantity Ordered is calculated by adding all of the qtyOrdered 

  Complete the following SQL to retrieve records for all Product and related records from ProductsBrowsed (where available).  Only include products that with dateIntroduced in the months of Jan, Feb, March of 2020 and belonging to Subcategory that is one of the following: hardware, electronics, appliances  Copy-paste the SQL from below into your answer and complete the remainder to meet the requirements. SELECT  P.*         , PB.* FROM PRODUCT P 

  In the above ER, all attributes shown in bold are not null. Which of the following correctly creates the table AIRPLANES?

CustID Cust Type City PostalCode SalesOrderNum ProductID OrderQty LineTotal ProductName ProductLine ProductListPrice 697 S Tooele 84074 SO50270 863 44 639.3717 Full-Finger Gloves, L M 37.99 146 L Seattle 98104 SO67266 869 41 1097.6182 Women’s Mountain Shorts, L A 69.99 697 S Tooele 84074 SO51783 867 40 1259.82 Women’s Mountain Shorts, S A 69.99 546 L Loveland 80537 SO57186 869 40 1259.82 Women’s Mountain Shorts, L A 69.99 546 L Loveland 80537 SO48089 863 39 666.7245 Full-Finger Gloves, L M 37.99 146 L Seattle 98104 SO67266 867 38 1196.829 Women’s Mountain Shorts, S A 69.99 697 S Tooele 84074 SO51783 869 36 1133.838 Women’s Mountain Shorts, L A 69.99 302 S Offenbach 63009 SO51109 864 36 1028.7 Classic Vest, S S 63.5 125 S Stamford 06901 SO46610 863 35 598.3425 Full-Finger Gloves, L M 37.99 315 S Merritt Island 32952 SO46673 863 35 598.3425 Full-Finger Gloves, L M 37.99   Column Name Explanation Column Name Explanation CustID id used for each customer — always 3 digits OrderQty quantity of product ordered Cust Type single letter code for differentiating types of customer LineTotal total charge for product ordered City city of shipping address for order (shortest is 5 letters and longest is 15 letter) ProductName name of product PostalCode zip code of shipping address for order — always 5 digits ProductLine single letter code for differentiating types of products SalesOrderNum unique number for each order – always 2 letters and 5 digits ProductListPrice list price of product ProductID id of each product — always 3 digits       The themes for which data is going to be stores are identified are: CUSTOMER, ORDER,  PRODUCT and PRODUCT ORDERED Based on the information, which of the following themes are related to: ORDER

CustID Cust Type City PostalCode SalesOrderNum ProductID OrderQty LineTotal ProductName ProductLine ProductListPrice 697 S Tooele 84074 SO50270 863 44 639.3717 Full-Finger Gloves, L M 37.99 146 L Seattle 98104 SO67266 869 41 1097.6182 Women’s Mountain Shorts, L A 69.99 697 S Tooele 84074 SO51783 867 40 1259.82 Women’s Mountain Shorts, S A 69.99 546 L Loveland 80537 SO57186 869 40 1259.82 Women’s Mountain Shorts, L A 69.99 546 L Loveland 80537 SO48089 863 39 666.7245 Full-Finger Gloves, L M 37.99 146 L Seattle 98104 SO67266 867 38 1196.829 Women’s Mountain Shorts, S A 69.99 697 S Tooele 84074 SO51783 869 36 1133.838 Women’s Mountain Shorts, L A 69.99 302 S Offenbach 63009 SO51109 864 36 1028.7 Classic Vest, S S 63.5 125 S Stamford 06901 SO46610 863 35 598.3425 Full-Finger Gloves, L M 37.99 315 S Merritt Island 32952 SO46673 863 35 598.3425 Full-Finger Gloves, L M 37.99   Column Name Explanation Column Name Explanation CustID id used for each customer — always 3 digits OrderQty quantity of product ordered Cust Type single letter code for differentiating types of customer LineTotal total charge for product ordered City city of shipping address for order (shortest is 5 letters and longest is 15 letter) ProductName name of product PostalCode zip code of shipping address for order — always 5 digits ProductLine single letter code for differentiating types of products SalesOrderNum unique number for each order – always 2 letters and 5 digits ProductListPrice list price of product ProductID id of each product — always 3 digits       The themes for which data is going to be stores are identified are: CUSTOMER, ORDER,  PRODUCT and PRODUCT ORDERED Based on the information, which of the following themes are related to: CUSTOMER

  Which of the following SQL queries only shows FLIGHTS that begin fromAirport that end with C and go toAirport begin with letter S with a stopOverAirport?

  Based on the ER above — The foreign keys in ProductsBrowsed entity allow: