Graded-EKCT 1027 TSQL Homework 1-Olajumoke Abiodun.sql - -...

-- Header block comment missing -- Yomi
--Based on the CaterDB database, please answer questions 1 3.
-- 1. Write a query that returns all the rows and columns in the Delivery
table.
-- 2. Write a query that returns the first name, last name, Phone, Birth Date,
Email, Address, City, State and PostalCode of all customers.
Select
FirstName,
LastName,
Phone,
DateOfBirth AS BirthDate,
Email,
Address,
City,
State,
PostalCode
From dbo.Customer -- Nice!
-- 3. Return a list of Payment ID, Payment Amount, and payment dates for
all payments
Select
PaymentID,
PaymentAmount,
PaymentDate
From dbo.Payment -- Nice!
-- Based on the AdventureWorks2017 database, please answer questions 4
10.