Question

Using SQL, present a list of bikes made by the company "Haro" in alphabetical order.

Answer 1

Write a query that selects all the rows from the 'bikes' table where the company is 'Haro' and sorts the result in ascending order based on the 'bike_name' column.

Step-by-step explanation:

To present a list of bikes made by the company 'Haro' in alphabetical order using SQL, you can write the following query:

SELECT * FROM bikes WHERE company = 'Haro' ORDER BY bike_name ASC;

This query selects all the rows from the 'bikes' table where the company is 'Haro' and sorts the result in ascending order based on the 'bike_name' column.