Search for question
Question

Problem 8: Establish a database view called LowRowlettBikesInventory View that lists the

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