Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Here is the SQL query for each of the requirements 1 Display the product name modelyear and lis...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started