Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Query 7 What orders shipped late? (show all of the fields) Query 8 are the company names, contacts, city, country, and region of Northwir CompanyName,

image text in transcribed
image text in transcribed
Query 7 What orders shipped late? (show all of the fields) Query 8 are the company names, contacts, city, country, and region of Northwir CompanyName, ContactName, City, Country, Region FROM Customers rmation Interface Help Data for Orders Messages Information History Required Date ID EmployeeID OrderDate ShipVia Freight ShipName 5 1996-07-04 00:00:00 1996-08-01 00:0000 1996-07-16 00:00:00 3 32.3800 Vins et alcools 116100 Toms Spezialit 65.8300 Hanari Cames 1 41.3400 Victuailles en stc 6 1996-07-05 00:00.00 1996-08-16 00:00:00 1996-07-10 00:00:00 4 1996-07-08000000 996-08-05 00:00:00 1996-07-12 000000 3 1996-07-08 00:00:00 1996-08-05 00:00:00 1996-07-15 00:0000 4 1996-07-09 00:00:00 1996-08-0600:00.00 1996-07-11 00:00:00 3 1996-07-10 00:00:00 1996072400:00:00 199607-1600:00:00 5 1996-07-11 0000:00 1996-08-08 00:00:00 1996-07-23 00:00:00 9 1996-07-12 0000:00 1996-08-09 00:00:00 1996-07-15 0000-00 3 1996-07-15 00:00:00 1996-08-12 00:00:00 1996-07-17 00:00:00 4 1996-07-16 00:00:00 1996-08-13 00:00:00 1996-07-22 00:00:00 1 1996-07-17 0000:00 1996-08-14 00:00:00 1996-07-2300:0000 2 513000 Supres delice 2 58.1700 Hanari Carnos 2 22.9800 Chop-suey Chine 3 1483300 Richter Supermark 2 13.9700 Wellington Importa 3 81.9100 HILARIN-Abastos 1 140.5100 Emst Handel 4 1996-07-18 00:00:00 1996-08-15 00:00:00 1996-07-25 0000.00 3 3.2500 Centro comercial M 4 1996-07-19 00:00:00 1996-08-16 00.00:00 1996-07-29 000000 4 1996-07-19 00:00:00 1996-08-16 00:00.00 1996-07-30 000000 8 1996-07-22 00:00:00 1996-08-19 00:0000 1996-07-25 00:00:00 9 1996-07-23 00:00.00 1996-08-20 00:00:00 1996-07-31 0000.00 6 1996-07-24 00-00:00 1996-08-21 00:00:00 1996-08-23 00-00-00 2 1996-07-25 00:00:00 1996-08-22 00:00:00 1996-08-12 00:00.00 3 1996-07-26 00:00:00 1996090600:00:00 19960731 00:00:00 4 1996-07-29 00:00:00 1996-08-26 02:00.00 1996-08-06 00:00.00 8 1996-07-30 00:00:00 1996-08-27 00 00:00 1996-08-02 00:00:00 5 1996-07-31 00:00:00 1996-08-14 00:00:00 1996-08-09 00:0000 1 1996-08-01 00:00:00 1996-08-29 00:00:00 1996-08-02 00:00.00 6 1996-08-01 00:00:00 1996-08-29 00 00.00 1996-08-30 00:0000 6 1996-08-02 00:00:00 1996-08-30 00:00:00 1996-08-06 00:00:00 3 1996-08-05 00:00:00 199.09-02000000 1996-08-12 00:00:00 6 1996-08-06 00:00:00 1996-09-03 000000 1996-08-16 00.00:00 1 55.0900 Onlies Kseladen 2 3,0500 Que Delicia 3 48.2900 Rattlesnake Canyon 3 146 0600 Emst Handel 3 3 6700Folk och f HB 55.2800 Blondel pre et fis 3 25.7300 Wartian Horkku 3 66.2900 GROSELLA-Restaurant 1 4.5600 White Clover Markets 1 136 5400 Wartian Herkku 2 4.5400 Split Rail Beer &Ale 2 98.0300 Rattlesnake Canyon Gro 3 76.0700 QUICK-Stop 16.0100Vins et alcools Chevalier 830 record(s) 0.36 ms Showing records 1-100 SELECT

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of Database Management

Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman

1st edition

133405680, 9780133547702 , 978-0133405682

More Books

Students also viewed these Databases questions