giftid
G101
G102
G103
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
Another question on Engineering
Engineering, 04.07.2019 18:10
Aflywheel accelerates for 5 seconds at 2 rad/s2 from a speed of 20 rpm. determine the total number of revolutions of the flywheel during the period of its acceleration. a.5.65 b.8.43 c. 723 d.6.86
Answers: 2
Engineering, 04.07.2019 18:20
Acertain flow of air (at stp) has a velocity distribution given by v i (in ft/s). if this flow is going through a 4 ft square area in the yz-plane (centered at the origin), what is the mass flow rate (in lbm/s)?
Answers: 2
Engineering, 04.07.2019 18:20
Wiy doeres rere okhn a pump whon working betwon the same pressure range?
Answers: 2
Engineering, 04.07.2019 19:10
What are the major differences between injection molding and extrusion?
Answers: 2
You know the right answer?
Consider the table gift given below:
Table: gift
giftid
G101
G102
G103
giftid
G101
G102
G103
Questions
Mathematics, 16.12.2020 17:40
English, 16.12.2020 17:40
Geography, 16.12.2020 17:40
Mathematics, 16.12.2020 17:40
Biology, 16.12.2020 17:40
Mathematics, 16.12.2020 17:40
Mathematics, 16.12.2020 17:40
English, 16.12.2020 17:40
History, 16.12.2020 17:40
