subject
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?

ansver
Answers: 2

Another question on Engineering

question
Engineering, 03.07.2019 14:10
When at a point two solid phase changes to one solid phase on cooling then it is known as a) eutectoid point b) eutectic point c) peritectic point d) peritectoid point
Answers: 3
question
Engineering, 04.07.2019 18:10
Apump is used to circulate hot water in a home heating system. water enters the well-insulated pump operating at steady state at a rate of 0.42 gal/min. the inlet pressure and temperature are 14.7 lbf/in.2, and 180°f, respectively; at the exit the pressure is 60 lbf/in.2 the pump requires 1/15 hp of power input. water can be modeled as an incompressible substance with constant density of 60.58 lb/ft3 and constant specific heat of 1 btu/lb or. neglecting kinetic and potential energy effects, determine the temperature change, in °r, as the water flows through the pump.
Answers: 1
question
Engineering, 04.07.2019 18:10
The drive force for diffusion is 7 fick's first law can be used to solve the non-steady state diffusion. a)-true b)-false
Answers: 1
question
Engineering, 04.07.2019 18:10
Machinery that is a key part of the process and without which the plant or process cannot function is classifed as: (clo4) a)-critical machinery b)-essential machinery c)-general purpose machinery d)-none of the specified options.
Answers: 1
You know the right answer?
Consider the table gift given below: Table: gift
giftid
G101
G102
G103
Questions
question
Mathematics, 11.10.2020 07:01
question
Biology, 11.10.2020 07:01
question
Mathematics, 11.10.2020 07:01
question
Mathematics, 11.10.2020 07:01
question
Geography, 11.10.2020 07:01
question
Mathematics, 11.10.2020 07:01
question
Biology, 11.10.2020 07:01
question
Mathematics, 11.10.2020 07:01
question
Mathematics, 11.10.2020 07:01
Questions on the website: 13722363