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]
3 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]3 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
PLEASE HELP
Ad libitum [116K]

Answer:

D. Jessie needs to buy more eggs, flour, butter, and sugar.

Step-by-step explanation:

it is good to have more then none

4 0
2 years ago
Read 2 more answers
Compare -5 and -3.
Nuetrik [128]

Answer:

Simplifying then comparing both terms

−5 and −3, −5 is less than −3, which means that the first term is less than the second term.  −5 < −3

Step-by-step explanation:

Hope this helps have a good day^^

7 0
2 years ago
PLS HELP ILL GIVE BRAINLIEST!!!!!!!!
anastassius [24]

Answer:

It says it right there.

the answer that you need is 300

Step-by-step explanation:

Brainiest

8 0
2 years ago
Read 2 more answers
Bought three boxes totaling 151 book cost 50% more than the other two what was the price of the more expensive book 80 85 90 95
GenaCL600 [577]
Two cheaper books = x
more expensive = 1.5x
so, 2.5x=150
150/2.5=x=60
therefore the more expensive book = 90
7 0
3 years ago
Please help &lt;3
Aleksandr [31]

Answer:

x =3

Step-by-step explanation:

3(4x + 4) = 2(5x+9) - 12

First step is to open the brackets by multiplying. It becomes

3×4x + 3×4 = 2×5x + 2×9 -12

12x + 12 = 10x + 18 - 12

Collecting like terms on the right hand side and left hand side of the equation, it becomes

12x -10x = 18 -12 -12

2x = -6

Negative sign on the right hand side of the equation overwhelms the positive sign on left hand side of the equation. It becomes

2x = -6

x = -6/2 = -3

Checking

3(4×-3 + 4) = 2(5×-3+9) - 12

-24 = -12-12= -24

So x = -3

3 0
3 years ago
Other questions:
  • If the point (1, 5) lies on a circle whose center is at the origin, what is the equation of the circle?
    12·1 answer
  • A perfect square is the square of an integer. Of the integers from 2 through 99, how many have at least one perfect square facto
    5·1 answer
  • Why are perfect squares not prime numbers?
    6·1 answer
  • What is the estmate of 120
    8·2 answers
  • Sandy needs to make 6 bows to put on her presents. She plans to use 18 inches of ribbon for each bow. How much ribbon does Sandy
    6·1 answer
  • The cost for bowling includes $4.00 for shoes and $4.75 for each
    5·2 answers
  • ILL BRAINLIEST YOU AND GIVE YOU 30 EXTRA POINTS PLEASE HELP ME
    15·1 answer
  • Jada made 14 cups for of blueberry jam and divided the jam equally amoung 8 containers how much jam went in each container
    12·1 answer
  • In the right triangle shown,
    8·1 answer
  • Mr. Ammons is constructing a walkway through his rectangular Garden. The walkway runs diagonally as shown in the diagram. Which
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!