Table
output order
output
Question:
Output:
Table Name & Values:

Finding Updated Records

md

Table Name: ms_employee_salary

id: int

first_name: varchar

last_name: varchar

salary: int

department_id: int

Find the current salary of each employee assuming that salaries increase each year.

SELECT

r

SELECT column1, column2, ...

id, first_name, last_name, salary, department_id

FROM

r

FROM table_name;

Subtopic

WHERE

r

WHERE condition;

GROUP BY

Find the last time each bike was in use. Output both the bike number and the date-timestamp of the bike's last use (i.e., the date-time the bike was returned). Order the results by bikes that were most recently used.

SELECT
bike_number,
end_time,

ORDER BY
end_time [DESC]

FROM
dc_bikeshare_q1_2012