1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Aliun [14]
2 years ago
7

What are the truck ID’s of trucks that have carried small shipments. Small shipments are defined as those that weigh less than 8

00 pounds? (HInt: Avoid duplcates.)
Mathematics
1 answer:
Ivanshal [37]2 years ago
5 0

Table for the question is attached in the picture below :

Answer:

SELECT distinct(TRUCK_ID), WEIGHT from SHIPMENT where WEIGHT < 800 ;

Step-by-step explanation:

The Structured query language (SQL) defined above, returns only the TRUCK_ID and Weight column from the shipment table as they are the only two columns listed after the select keyword. The condition is added using the WHERE keyword on the weight table, this filters the result returned to include only rows where the weight value is less than 800. The distinct keyword used alongside the TRUCK_ID column ensures that a certian TRUCK_ID value isn't returned more than once (Hence, it is used to avoid duplicates).

You might be interested in
WILL GIVE BRAINLEST 100 POINTS PLZ HELP ME
yuradex [85]

Answer:

2

Step-by-step explanation:

Its the only graph that matches.

3 0
3 years ago
Read 2 more answers
Which type of transformation maps triangle GFH onto triangle G'F'H'?
lions [1.4K]

Answer:

rotation

Step-by-step explanation:

5 0
3 years ago
Read 2 more answers
A class has 15 boys and 16 girls. What is the probability that a boy's name is drawn at random?
melomori [17]
15 boys and 16 girls....total is (15 + 16) = 31

probability that a boys name is drawn : boys/total ppl = 15/31
6 0
3 years ago
27 divided by (3+6) time 5 - 12
adelina 88 [10]

Hello,

The answer to you question is 3.

27/(3+6) x 5 - 12 = 3

Hope it helps, Cheers.




7 0
3 years ago
5x + 10y = 18
SOVA2 [1]
5x + 10y = 18

x = y -6, we substitute this into first equation.

5x + 10y = 18

5*(y - 6) + 10y = 18

5y - 30 + 10y = 18

So it the last option from the top.
4 0
3 years ago
Read 2 more answers
Other questions:
  • The claim is that the proportion of accidental deaths of the elderly attributable to residential falls is more than 0.10, and th
    5·1 answer
  • Compute and compare the side lengths of the two figures. Does this support an argument claiming that they are congruent? What el
    10·2 answers
  • The perimeter of a square is 36<br>what is the area of the square?​
    12·1 answer
  • The answer to 8-n=-4n
    8·2 answers
  • A radioactive element has a half-life of six days. What is the approximate decay rate of the element after the first day?
    7·2 answers
  • in an ap,the first term of an arithmetic series is 5,the last term is 45 and the sum is 400. find the number of terms and common
    9·2 answers
  • Please help<br><br><br><br> Thank yoy
    5·2 answers
  • Question 4
    15·1 answer
  • What is the range of the function on the graph?
    7·1 answer
  • Show that h= r(csc(theta)-1)
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!