Consider the schema below, complete the following using the specified query language: Brands (brand id, brand_name)...

Transcribed Image Text:

Consider the schema below, complete the following using the specified query language: Brands (brand id, brand_name) Products (product_id, product_name, brand_id, category_id, model_year, list_price) Stocks (store id, product id, quantity) Customers (customer id, first_name, last_name, phone, email, street, city, state, zip_code) Orders (order id. customer id. order_status, order date, shipped_date, store_id, staff_id) Order_items (order id, item id, product_id, quantity, list_price, discount) Stores (store id, store_name, phone, email, street, city, state, zip_code) (RA) Display the product name, model_year and list price of all products with a list price greater than $6,000. (RA) Show the customer id, first name, last name, order id, and order status of all orders placed by customers that shipped from a store with id = 2. (TRC) Find the store_id, product_id, quantity and order status of all sales order where the shipped date is '2020-03-13' and the quantity greater than 1000 Consider the schema below, complete the following using the specified query language: Brands (brand id, brand_name) Products (product_id, product_name, brand_id, category_id, model_year, list_price) Stocks (store id, product id, quantity) Customers (customer id, first_name, last_name, phone, email, street, city, state, zip_code) Orders (order id. customer id. order_status, order date, shipped_date, store_id, staff_id) Order_items (order id, item id, product_id, quantity, list_price, discount) Stores (store id, store_name, phone, email, street, city, state, zip_code) (RA) Display the product name, model_year and list price of all products with a list price greater than $6,000. (RA) Show the customer id, first name, last name, order id, and order status of all orders placed by customers that shipped from a store with id = 2. (TRC) Find the store_id, product_id, quantity and order status of all sales order where the shipped date is '2020-03-13' and the quantity greater than 1000

Answer rating: 100% (QA)

Here is the SQL query for each of the requirements 1 Display the product name modelyear and lis... View the full answer