• 1. Please select all columns from Customers table with Age more than 62. How many customers are above age 62?

  • 2. Your manager asked you to find out WHAT AGE is the youngest customer who either lives in United Kingdom or his manager is Green. (Hint: what is the ID of the manager Green?) Please insert the correct answer.

  • 3. How many customers both have Emails on .edu domain and and the Country of Residence is known? (Hint: you can use COUNT(*) to count the number of records)

  • 4. How many positions in portfolio are there between 2000 and 3000.

  • Please format the SQL query using the best practices.

  • Input the answers of 1, 2,3,4 in https://forms.gle/BpCr8tBhX6Xx7Bow6

Last modified: Wednesday, 23 March 2022, 10:45 AM