MySQL

Query

MSQL

Query

3. Write a SELECT statement without a FROM clause that uses the NOW function to create a row with these columns today_unformatted The NOW function unformatted today_formatted The NOW function in this format: DD-Mon-YYYY This displays a number for the day, an abbreviation for the month, and a four-digit year. Try displaying today's date in different formats like: '01/2020 -- mm/yyyy 30/01/2020 -Dd/mm/yy 30th January 2020. --- doth month yyyy Table 1 today_unformatted today_formatted 2021-01-31 15:23:17 31-Jan-21 4. Write a SELECT statement that joins the Musicians table to the Addresses table and returns these columns: first_name, last_name, linel, city, state, zip_code. Return one row for each address for the musician with an email address of david.goldstein@hotmail.com Line1 State zip code first_name David David last name Goldstein Goldstein Table 1 city 186 Vermont St. San Francisco 1374 46th Ave. San Francisco CA 94110 CA 94129