Assuming the select statement below is a proper query, which is true regarding the following statement?
create view example as
select vendor_name, sum(invoice_total) as "invoice sum"
from vendors join invoices on vendors. vendor_id = invoices. vendor_id
group by vendor_name order by vendor_name; (points : 4)
(a) it will fail because the group by clause is not allowed in a view.
(b) it will fail because sum function is not allowed in a view.
(c) it will fail because order by clause is not allowed in a view.
(d) it will succeed.

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.

Fluids at rest possess no flow energy. a)- true b)- false

Water in a partially filled large tank is to be supplied to the roof top, which is 8 m above the water level in the tank, through a 2.2-cm-internal-diameter pipe by maintaining a constant air pressure of 300 kpa (gage) in the tank. if the head loss in the piping is 2 m of water, determine the discharge rate of the supply of water to the roof top in liters per second.