Have a question?
Message sent Close

CIS336 Introduction to Database From Customers Join Orders DeVry University

0
0 reviews
  • Description
  • Full Document
Blur-Preview

DeVry University

CIS336 Introduction to Database From Customers Join Orders DeVry University

ELECT order_id, order_date,
CONCAT (customer_first_name, ‘ ‘, customer_last_name) AS Customer,
customer_city
FROM customers JOIN orders
ON customers.customer_id = orders.customer_id
WHERE customer_state = ‘OH’
ORDER BY order_date DESC;
order_id order_date Customer customer_city
824 2014-08-01 Korah Blanca Columbus
479 2014-01-30 Korah Blanca Columbus
442 2013-12-28 Kendall Mayte Cleves
19 2012-10-23 Korah Blanca Columbus
Solution 2:
SELECT order_id, order_date, shipped_date
FROM customers JOIN orders
USING (customer_id)
WHERE customer_first_name = ‘Karina’ AND customer_last_name = ‘Lacy’
AND shipped_date IS NOT NULL;
order_id order_date shipped_date
158 2013-04-04 2013-04-20
264 2013-07-15 2013-07-18
693 2014-06-07 2014-06-19

Preview

CIS336 Introduction to Database From Customers Join Orders DeVry University

 

NOTE: Please check the details before purchasing the document.

error: