basic sql query

SELECT * from Customer  order by FirstName

SELECT * from Customer WHERE FirstName like '[a-a]%'  order by FirstName

SELect distinct city from Customer order by City


  SELECT DATEPART(YEAR, [OrderDate]) FROM [Order]
  SELECT COUNT(*) from Customer

  SELECT * from [dbo].[Order]  order by NEWID()
   SELECT top 5 customerId, sum(TotalAmount) from [order]
group by CustomerId
order by  sum(TotalAmount) desc