Question: write a SQL query that retrieves the product _ id values from the sales table where the customer _ id is equal to 1 0

write a SQL query that retrieves the product_id values from the sales table where the customer_id is equal to 1002.
SQL Table with the following schema -
Tables Schema as Below:
sales
columnName dataType
id INTEGER
customer_id INTEGER
product_id INTEGER
sale_date DATE
amount DECIMAL(10,2)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Use sh schema to solve the following questions: Q 1 . Retrieve the unit _ price and channel _ ID categorized by channel class. Q 2 . Write a SQL query to return the Product ID , Customer ID , Channel...

Q:

At Bird Company, an order is recorded in two separate tables as follows. The table titled orders contains a single record of header information for each order in the following fields: order number...

Q:

Problem 4 [25 points]. There are six tables describing a company, describing employees, departments, buildings, which department(s) an employee works in (and a percentage of the time for each),...

Q:

CREATE TABLE SALES ( SALE_ID INTEGER, PRODUCT_ID INTEGER, YEAR INTEGER, QUANTITY INTEGER, PRICE INTEGER ); Write a SQL query which retrieves product it and total quantity of bestselling product...

Q:

CREATE TABLE SALES ( SALE_ID INTEGER, PRODUCT_ID INTEGER, YEAR INTEGER, QUANTITY INTEGER, PRICE INTEGER ); Consider the product schema (given above) to answer the following questions. Write a SQL...

Q:

This question is in relation to relational databases and MySQL. I've done a, b and c . I need help with d, e and f. I did a like this: SELECT name FROM people; I did b like this: SELECT name, office...

Q:

*Please write out the queries that would be entered into a SQL Server* Complete the queries listed below in SQL Server. Use AdventureWorks2014 database to work on the assignment. When creating a new...

Q:

Question No 2 [10 marks] CREATE TABLE SALES ( SALE_ID INTEGER, PRODUCT_ID INTEGER, YEAR INTEGER, QUANTITY INTEGER, PRICE INTEGER ); Consider the product schema (given above) to answer the following...

Q:

Problem: Northwind Traders is a leading international supplier of food and beverages. They have an extensive network of suppliers around the world and customers spread across different countries....

Q:

Question: Consider the ZAGI database from the textbook. The ER diagram and relational schema are on page 77 in Figure 3.32. Sample data is on page 77 in Figure 3.33. (Use the SQL to create the...

Q:

A firm has $4,100,000 in its common stock account and $41,000,000 in its paid in capital account. The firm issued 410,000 shares of common stock. What was the issue price (market value) if only one...

Q:

This case represents an actual retail company. The dates and format have been changed. Required a. Compute and comment on the following for 2005, 2006, and 2009: 1. Working capital 2. Current ratio...

Q:

21. The sets 5, X and Y satisfy the conditions n() = 11, n(X) 4 and n(Y) = 7. Find = (i) the smallest possible value of n(XY)', (ii) the largest possible value of n(XY)'.

Q:

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Q:

(Appendices) The Social Security trust funds are invested in government securities that are both similar and dissimilar to other government securities available to the Public. LO4 a. Explain how the...

Q:

(Appendices) Permanent partial workers compensation claims are costly and often difficult to administer. The states use different methods to compensate injured workers for such claims. LO4 a. What is...

Q:

(Appendices) The Original Medicare Plan consists of Hospital Insurance (Part A) and Medical Insurance (Part B). For each of the following losses, indicate whether the loss is covered under Medicare....