Engineering, 02.04.2021 09:30 triciajfive

Consider the table gift given below: Table: gift
giftid
G101
G102
G103
G104
G105
G106
giftname
Magic Mug
Golf Set
Little Astronomer
Renoir Paintings
French Gastronomy
Magic Set
price
500
3550
2000
1500
3000
1300
discount availability
9
10
5
15
20
18
15
15
7
10
30
30
Query:
SELECT g1.giftid, g1.giftname FROM gift g1 JOIN gift g2
ON g1.availability=g2.availability AND g1.discount>g2.discount
WHERE g1.discount>7
How many rows will be fetched when the above query gets executed?

Answers: 2

Show answers

Other questions on the subject: Engineering

Engineering, 03.07.2019 15:10, margaret1758

If you were designing a bumper for a car, would you prefer it to exhibit elastic or plastic deformation? why? consider the functions of a bumper in both a minor "fender-bender" and a major collision.

Answers: 1

continue

Engineering, 04.07.2019 18:10, tjeffers90028

Refrigerant 134a enters an insulated compressor operating at steady state as saturated vapor at -26°c with a volumetric flow rate of 0.18 m3/s. refrigerant exits at 9 bar, 70°c. changes in kinetic and potential energy from inlet to exit can be ignored. determine the volumetric flow rate at the exit, in m3/s, and the compressor power, in kw.

Answers: 1

continue

Engineering, 04.07.2019 18:10, Fahaddie

The thermal expansion or contraction of a given metal is a function of the f a)-density b)-initial temperature c)- temperature difference d)- linear coefficient of thermal expansion e)- final temperature f)- original length

Answers: 2

continue

Engineering, 04.07.2019 18:10, selenamr

Ifa component is made of two or more materials with different modulus of elasticity (e), it is called a composite member and we calculate the factor·n". mention the formula for calculating n". also, ifn> 1, explain what will happen to the 1. transformed. gi) ifn 1, what will happen to the material when transformed material when

Answers: 1

continue

You know the right answer?

Consider the table gift given below: Table: gift
giftid
G101
G102
G103