all of them

1. Translate the following statement into SQL: "Show me all of our customers first names, last names, and phone numbers who live in California." a. Use sales.Customers table b. Include all four steps of the translation process 2. Translate the following statement into SQL: "Give me the current students first names, last names, state and age in alphabetical order by last name." a. Use school Students table b. Only provide the SQL 3. Translate the following statement into SQL: "Give me the goals per shots ratio for players who were on the ice for more than 10 minutes and had more than 3 shots." a. Use nhl.game_skater_stats b. Only provide the SQL C. Hint: time_on_ice is in seconds 4. Translate the following statement into SQL: "Show me the last name, salary, and date hired for our staff hired between 1991 and 1996." a. Use school Staff b. Include all four steps of the translation process 5. Translate the following statement into SQL: "Show me the 3 staff members with the most seniority ordered by years of service descending." a. Use school Staff b. Only provide the SQL FUmditing All submitted files should use the following header. Exercises should be clearly labeled using the format below. WEEKLY EXERCISE 01 JULI LISSER 2019-09-03 EXERCISE 101 EXERCISE 27 SQL solutions should be formatted like the example below: All keywords should be capitalized Primary keywords (e.g. SELECT, FROM, WHERE, ORDER BY) should be aligned to the left margin If an additional line is needed between primary keywords indent the line once SELECT BowlerLastName. Bowler FirstName, Bowler Phone Number CAST(TeamID AS CHAR) AS 'TeamID' FROM bowl. Bowlers WHERE BowlerMiddleInit IS NOT NULL AND Bowlerstate = 'WA ORDER BY BowlerLastName In general submitted SQL queries should look like the query examples in the text and presentations server: infost410.database.windows.net username: infost410student password: infost410secret! database: DemoDB