# Query the Data-Bikeshare data
![left](./student-guide/diagram/QueryDataBikeshareData_en_001_20220525.png)
------------------------------------------------------------
Reopened the Web SQL Shell
    Required to login again


Query data

When the process of importing data is completed, you can start to run some queries in your Terminal:

Use the bikeshare database and tables:

USE bikeshare; SHOW tables; 

Check the structure of the trip table:

DESCRIBE trips; 

Check how many records exist in the trips table:

SELECT COUNT(*) FROM trips; 

Check the entire trip history where the start station is "8th & D St NW":

SELECT * FROM trips WHERE start_station_name = '8th & D St NW'; 

Show the least ten popular bicycle stations for picking up:

SELECT start_station_name, COUNT(ride_id) as count from `trips` GROUP BY start_station_name ORDER BY count ASC LIMIT 10;