Question: Question 19 7 Points LSI would like to send an email at the beginning of every month to congratulate users on their birthdays. As a

 Question 19 7 Points LSI would like to send an emailat the beginning of every month to congratulate users on their birthdays.

Question 19 7 Points LSI would like to send an email at the beginning of every month to congratulate users on their birthdays. As a test run, they have decided to send an email to all users whose birthday is December. Post User P id INT Comment Pid INT text VARCHAR(280) id INT name VARCHAR(128) creation_date DATETIME # text VARCHAR(280) likes INT email VARCHAR(320) creation_date DATETIME I author_id INT likes INT username VARCHAR(128) Indexes password VARCHAR(32) 1 post_id INT city VARCHAR(45) I author_id INT Indexes country VARCHAR(45) Community time_zone VARCHAR(45) Pid INT ip_address VARCHAR(45) name VARCHAR(32) date_of_birth DATE #followers INT job VARCHAR(45) description VARCHAR(128) phone_number VARCHAR(45) creation_date DATETIME Indexes Indexes Friendship Community_has_User friend_a_id INT Community_id INT friend_b_id INT I User_id INT creation_date DATETIME Indexes Indexes Your job is to create a SQL statement that retrieves users' names, birthdates, and emails for the test run. SELECT name, email, Blank 1 FROM Blank 2 Blank 3 MONTH(Blank 4)=Blank 5; Below is a screen capture that captures some of the records you need to obtain for the test run.Below is a screen capture that captures some of the records you need to obtain for the test run. Larry Kline jessicaballard@gmail.com 1912-12-28 Shane Ballard DDS schwartzdonald@gmail.com 2011-12-07 lan Higgins sarah86@yahoo.com 1924-12-15 Alec Davenport jfox @hotmail.com 2009-12-15 Christopher Gonzalez shelley60@hotmail.com 1987-12-09 Brian Larson robertsmith @yahoo.com 1968-12-17 Christopher Mccullough gevans@gmail.com 2007-12-14 Stephen Castillo jeffreylee @gmail.com 1947-12-10 Jason Gentry gregory80@gmail.com 1970-12-31 Edward Stafford sarahmiller@gmail.com 1969-12-14 Bryan Gonzalez mary09@gmail.com 2017-12-28 Brenda Levine bramirez@hotmail.com 1926-12-16 Brent Flores alejandro71@yahoo.com 2008-12-14 Kelsey Clark mary07@hotmail.com 1972-12-28 Blank 1 Add your answer Blank 2 Add your answer Blank 3 Add your answer Blank 4 Add your answer Blank 5 Add your

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!