Search for question
Question

Problem 9: Establish a database view called LowCostBikes View that lists the bikes costing

$200 or less. The view needs to contain the bike name, brand name, and list price. Then

execute a SELECT query to verify the view.

Expected Output:

product_name

Trek Boy's Kickster - 2015/2017

Sun Bicycles Lil Kitt'n - 2017

Trek Girl's Kickster - 2017

Trek Precaliber 12 Boys - 2017

Trek Precaliber 12 Girls - 2017

Strider Classic 12 Balance Bike - 2018

Trek Precaliber 12 Girl's - 2018

Trek Kickster - 2018

Trek Precaliber 12 Boy's - 2018

brand_namelist_price

Trek

Sun Bicycles

Trek

Trek

Trek

Strider

Trek

Trek

Trek

149.99

109.99

149.99

189.99

189.99

89.99

199.99

159.99

199.99

Fig: 1