Assignment 1: SELECT statement
1. Please write a query that extracts all columns and rows from AccountManagers table.
2. Please extract columns CustomerID, CustomerEmail, AccountManagerID from Customers table. Please format the SQL query using the best practices.
3. Run and print screen of the query in p.2
4.<fac_num>_name_select.jpg
5. https://forms.gle/7YRmC4CehbdGBBby7
6. Please select columns Customer, CountryResidence, AmountPosition from Customers table. What error do you get?
2. Please extract columns CustomerID, CustomerEmail, AccountManagerID from Customers table. Please format the SQL query using the best practices.
3. Run and print screen of the query in p.2
4.<fac_num>_name_select.jpg
5. https://forms.gle/7YRmC4CehbdGBBby7
6. Please select columns Customer, CountryResidence, AmountPosition from Customers table. What error do you get?
Last modified: Wednesday, 16 March 2022, 2:13 PM