Basic SQL Queries

.docx

School

Utah State University *

*We aren’t endorsed by this school

Course

2100

Subject

Information Systems

Date

Dec 6, 2023

Type

docx

Pages

Uploaded by KidFreedom5699

Brett Chase Bruggeman A02231449 DATA 2100 HW Minor – Basic SQL Queries Part A 1. Table Primary Key Customer CustID Product ModelID OrderLine OLID Region RegionID SalesOrder SOID Service SvcID USState StateID Part B 2.

SELECT all FROM Region;

3. SELECT ModelID, MSRP FROM "Product" ORDER BY ModelName asc; 4. SELECT StateName, Population, RegionID

FROM USState WHERE Population > 15000000 ORDER By Population desc; 5. SELECT StateName, Population

FROM USState WHERE StateName like 'N%' and Population > 3000000 ORDER By StateName asc; 6. SELECT Fname, Lname, Children, Marital, CustState

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help