I'm using a particular database using SQL Server and need help writing the following SQL statements/queries.

3. Write a SELECT statement that returns these columns from the addresses table. CustomerID, Line1, Line2, City, State, ZipCode. Only return addresses from the state of New York. 4. Write a SELECT statement that returns these columns from the Orders table. OrderID, ShipAmount, CardType, CardNumber, CardExpires. Use the alias ORD for the Order table. Only return Orders with a cardType of Visa. Sort the result set by order Date asc 1