Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the northwind database, write SQL statements to: categories 123 category_id ADC category_name ABC description picture employee_territories 123 employee_id noc territory_id E products 123 product_id

image text in transcribedUsing the northwind database, write SQL statements to:

image text in transcribed

categories 123 category_id ADC category_name ABC description picture employee_territories 123 employee_id noc territory_id E products 123 product_id ADC product_name 123 supplier_id 123 category_id ADC quantity_per_unit 123 unit_price 123 units_in_stock 123 units_on_order 123 reorder_level 123 discontinued suppliers 123 supplier_id ADC company name ADC contact name ADC contact_title AC address AC City ABC region ABC postal code AC country noc phone Ac fax Anc homepage employees 123 employee_id AC last name ABC first_name ADC title Actitle_of_courtesy birth_date hire_date AC address ABC City AC region ABC postal code Accountry AC home_phone ADC extension D photo ADC notes 123 reports_to ADC photo_path territories ac territory_id ADC territory_description 123 region_id region 123 region_id RDC region_description order_details 123 order_id 123 product_id 123 unit_price 123 quantity 123 discount customers ADC customer_id ABC company name ADC contact name ADC contact_title AC address Ac city Borders 123 order_id AC customer_id 123 employee_id orderd required_date shipped date 123 ship via 123 freight AC ship name AC ship address ac ship_city ABC ship region ADC Ship postal code ABC ship country ADC region Bus states BB customer customer_demo ADC customer_id ADC customer_type_id ADC postal code ABC country ABC phone ADC fax shippers 123 shipper_id ABC company name Ac phone 123 state id noc state_name ADC state_abbr ADC state region 3 customer_demographics ADC customer_type_id ADC customer desc 5. For each order, list the order id and the number of days between when it was ordered and when it shipped 6. Create a new customer (you may make up the appropriate details) categories 123 category_id ADC category_name ABC description picture employee_territories 123 employee_id noc territory_id E products 123 product_id ADC product_name 123 supplier_id 123 category_id ADC quantity_per_unit 123 unit_price 123 units_in_stock 123 units_on_order 123 reorder_level 123 discontinued suppliers 123 supplier_id ADC company name ADC contact name ADC contact_title AC address AC City ABC region ABC postal code AC country noc phone Ac fax Anc homepage employees 123 employee_id AC last name ABC first_name ADC title Actitle_of_courtesy birth_date hire_date AC address ABC City AC region ABC postal code Accountry AC home_phone ADC extension D photo ADC notes 123 reports_to ADC photo_path territories ac territory_id ADC territory_description 123 region_id region 123 region_id RDC region_description order_details 123 order_id 123 product_id 123 unit_price 123 quantity 123 discount customers ADC customer_id ABC company name ADC contact name ADC contact_title AC address Ac city Borders 123 order_id AC customer_id 123 employee_id orderd required_date shipped date 123 ship via 123 freight AC ship name AC ship address ac ship_city ABC ship region ADC Ship postal code ABC ship country ADC region Bus states BB customer customer_demo ADC customer_id ADC customer_type_id ADC postal code ABC country ABC phone ADC fax shippers 123 shipper_id ABC company name Ac phone 123 state id noc state_name ADC state_abbr ADC state region 3 customer_demographics ADC customer_type_id ADC customer desc 5. For each order, list the order id and the number of days between when it was ordered and when it shipped 6. Create a new customer (you may make up the appropriate details)

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

Step: 3

blur-text-image

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

101 Database Exercises Text Workbook

Authors: McGraw-Hill

2nd Edition

0028007484, 978-0028007489

More Books

Students also viewed these Databases questions

Question

I just need a answers 0.0 CD AM 9.4 OC e -Q CHO)

Answered: 1 week ago