Question: 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.

 Starting SQL Statements Based on your developing knowledge of SQL, you

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!