bikes with stock levels less than 2 at the Rowlett Bikes store. The view needs to contain the bike
name, brand name, and stock quantity amount. Then execute a SELECT query to verify the
view.
Expected Output:
product_name
Surly Wednesday Frameset - 2016
Haro SR 1.2-2017
Trek Domane S 5 Disc - 2017
Sun Bicycles Lil Bolt Type-R - 2017
Electra Moto 3i (20-inch) - Boy's - 2017
Sun Bicycles Streamway 7-2017
Sun Bicycles Cruz 3-2017
Trek Domane SLR 8 Disc - 2018
Trek Domane ALR 4 Disc Women's - 2018
Trek Domane SL 5 Disc Women's - 2018
Trek Domane SLR Disc Frameset - 2018
Trek Crockett 7 Disc - 2018
Electra Cruiser 1 Ladies' - 2018
Electra Koa 3i Ladies' - 2018
Electra Townie Commute 27D - 2018
Electra Amsterdam Royal 8i Ladies - 2018
Trek Superfly 24-2017/2018
Electra Heartchya 1 (20-inch) - Girl's - 2018
Electra Townie Original 1 Ladies' - 2018
brand name quantity
Surly
0
Haro
1
Trek
0
Sun Bicycles
1
Electra
1
1
1
1
Sun Bicycles
Sun Bicycles
Trek
Trek
Trek
Trek
Trek
Electra
Electra
Electra
Electra
Trek
Electra
Electra
1
1
1
1
0
1
1
0
1
1
0
Fig: 1