HW16

sql

School

Tulsa Community College *

*We aren’t endorsed by this school

Course

1013

Subject

Computer Science

Date

Oct 30, 2023

Type

sql

Pages

2

Uploaded by CorporalChimpanzee344

Report
use F22_thazelr; go SELECT CustName FROM customer WHERE CustID = 11; select CityID from shipment where ShipmentID=19 select distinct TruckID from shipment where ShipWeight>1000 SELECT * FROM shipment WHERE ShipWeight >=135; SELECT CustName FROM customer WHERE AnnualRevenue > 3 ORDER BY CustName ASC; Select CustName, AnnualRevenue from Customer where AnnualRevenue > 1500000 and AnnualRevenue < 2500000 select distinct custID as Customer_Id from shipment st where cityId>=41 and cityId<=50; select cityName as City_Name from city ct where cityID between 41 and 50; select cityId as City_ID, cityName as City_Name from city ct where cityName like 'B%'; select max(ct.CityPop) as the_population_of_the_largest_city, min(citypop) as the_population_of_the_smallest_city, avg(citypop) as the_population_of_the_average_city
from city ct; select CityName as City_Name from city cy where CityName like '%ea%'; select CityName as City_Name from city cy where CityName like 'C%a%'; select CityName as City_Name from city cy where CityName like 'New_____'; select distinct CustType as Customer_Type from Customer ct; select custName as Custmer_Name,AnnualRevenue as Annual_Revenue from customer ct where custType!='Retail'; select ShipmentID from Shipment sh where ShipWeight>500 and cityID=23; select ShipmentID as Shipment_ID,TruckID as Truck_ID,ShipWeight as Ship_Weight from shipment sh where month(shipdate) in (6,7,8) and year(shipdate)=2007 order by shipdate; select count(distinct custID) as Number_of_unique_customers from shipment sh; select count(distinct custID) as Number_of_unique_customers from shipment sh; select count(custID) as Number_of_customers from shipment sh where ShipWeight>500;
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

Related Documents

IMG_1893.jpeg
Note (8).pdf
10374811-99C1-43E7-97D2-8BA6F0351F6E.png
8E7A0444-520A-4956-910B-646768967B1A.png
Screenshot 2023-10-29 151916.png
CMSC 000-Class 4-781.pdf
Screen Shot 2023-10-24 at 10.38.02 PM.png
IMG_4742.jpeg
tt.png
4.PNG
hw03.pdf
hw05b_blank.pdf
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
SEE MORE TEXTBOOKS

Browse Popular Homework Q&A

Q: After initialization, we found our convolutional neural network’s training loss does not go down,…
Q: A drawback of a sole proprietorship is: O a. the unlimited liability of the partners. Ob. conflicts…
Q: Increased blood vessel formulation is a predictive factor in survival for a certain disease. One…
Q: According to Boyle's Law, as pressure decreases what do you expect will happen to the volume?  A.…
Q: Match the Skill to the Skill description. Identifying your own emotions and the impact they have on…
Q: 26. Write the expression for a number used as a factor fifteen times being multiplied by the same…
Q: Normalize the wavefunction re-r/2a in three-dimensional space
Q: spam filer is designed by screening commonly occurring phrases in spam. Suppose that 60% of email is…
Q: The probability that a card drawn from a pack of 52 cards will be a diamond or a king, is.
Q: Write an equation for a line parallel to y= -3x + 4 and passing through the point (3, -7)
Q: The following Tale was found among the papers of the late Diedrich Knickerbocker, an old gentleman…
Q: 3. A student places a piece of copper with a mass of 125.0 grams and an initial temperature of 99.00…
Q: Why are air masses usually warmer and more humid in summer than in winter
Q: The probability that a card drawn from a pack of 52 cards will be a diamond or a king, is.
Q: An entity-relationship model is one of the most challenging aspects of designing a database because…
Q: Jim has received scores of 70 and 73 on his first two 100 point tests. What score must he get on his…
Q: If $1,034,000 of 6% bonds are issued at 102 3/4, the amount of cash received from the s Oa.…
Q: Solve the following systems of inequalities by graphing: 1. 3x + 4y < 28 x- 2y < 0
Q: In Exercises 1-6, graph the given equations and determine how many solutions the system has, if any.…
Q: |x-1|=5x+10
Q: 5. Write an expression to represent the following situation: A hot air balloon rises 14 feet for…
Q: d Use the divergence theorem to find the total flux out of the solid 0≤x≤1, 0≤ y ≤1-x, 0≤z≤1-x-y,…
Q: The physician orders Medication L 400 mg PO twice daily. The pharmacy supplies Medication L with a…
Q: What is meant by hardware multithreading?
Q: Determine whether the given statement is true or false. The Seven Years' War was a cause of the…