Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Starting SQL Statements Based on your developing knowledge of SQL, you should be able to formulate basic functional and effective SELECT statements at this point.

image text in transcribed

Starting SQL Statements Based on your developing knowledge of SQL, you should be able to formulate basic functional and effective SELECT statements at this point. For this assignment, consider the database we have been studying in class ("SQL Tryit Editor v1.6- W3Schools"). The tables and their fields are listed below: Table Fields CustomerlD, CustomerName, ContactName Address, City, PostalCode, Count CategoryID, CategoryName, Description EmployeelD, LastName, FirstName, BirthDate, Photo, Notes OrderDetaillD, OrderlD, ProductID, Quanti OrderlD, CustomerlD, EmployeelD, OrderDate Customers Categories Employees OrderDetails Orders pperlD ProductID, ProductName, SupplierlD, CategoryID, Unit, Price ShipperlD, ShipperName, Phone SupplierlD, SupplierName, ContactName, Address, City, PostalCode, Country, Phone Products Shippers Suppliers For each inquiry below, compose a SELECT statement which would return data to provide appropriate results. You are free to specify any table(s) and corresponding field(s) that exist in the database in each query. Please try to use different tables and fields for each query (i.e don't use the same table and fields for each statement) 1. all fields from any table 2. three different fields from any table 3. all fields from any table, match a single condition based on a single field 4. two different fields from any table, match two condition based on a single field 5.all fields from any table, match two conditions based on two fields (be careful with operators such as-, , BETWEEN, AND, OR, etc.; improper combinations might not produce practical results) You may want to test your query using the SQL Tryit Editor v1.6 - W3Schools Web page or some other site that can verify your statements Type your correctly functioning SELECT statements in a document of some kind (you can use Notepad, Wordpad, MS Word, etc.). Save the completed document as "MIT622 Week 2 Online Assignment Your Name" and submit for grading

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

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2018 Dublin Ireland September 10 14 2018 Proceedings Part 1 Lnai 11051

Authors: Michele Berlingerio ,Francesco Bonchi ,Thomas Gartner ,Neil Hurley ,Georgiana Ifrim

1st Edition

3030109240, 978-3030109240

More Books

Students also viewed these Databases questions

Question

Determine the amplitude and period of each function.

Answered: 1 week ago

Question

3. What are potential solutions?

Answered: 1 week ago