Question
Write SQL queries to answer this question What customers (ordNo, cid and cname) ordered a product from Duluth (city in tblProducts)? ordno | cid |
Write SQL queries to answer this question
What customers (ordNo, cid and cname) ordered a product from Duluth ("city" in tblProducts)?
ordno | cid | cname
-------+------+--------
1017 | c001 | Tiptop
1018 | c001 | Tiptop
1013 | c002 | Basics
1026 | c002 | Basics
(4 rows)
Step by Step Solution
3.36 Rating (165 Votes )
There are 3 Steps involved in it
Step: 1
Objective The purpose of the given SQL query is to get a list of customers who placed orders from the city of Duluth Specifically the query attempts to find the following information for each customer ...
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
Database Concepts
Authors: David M. Kroenke, David J. Auer
7th edition
133544621, 133544626, 0-13-354462-1, 978-0133544626
