Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started