1) List every member\'s name in the form last name comma first name (for example
ID: 3835829 • Letter: 1
Question
1) List every member's name in the form last name comma first name (for example: Smith, Bob) and their telephone number sorted alphabetically by name
2) List the first name, last name, and birthday of everyone whose birthday is after July 4, 2005
3) List the first name, last name, and birthday of everyone who was born in the month of November
4) List the first name, last name, and how old they were on January 1, 2000 of everyone who was born before that date
5) List everyone's first name, last name, and area code
6) Give everyone's last name in all uppercase
7) List everyone's first name, last name, and how old they are right now (this query should give the current age whenever it is run, not just on the day of the lab)
Explanation / Answer
Select concat(LastName, ',', FirstName) as NAME from Members ORDER BY NAME; Select FirstName, LastName, Birthday from Members where date > 7/4/2005 Select FirstName, LastName, Birthday from Members where month(date) = 11. select FirstName, LastName, DATEDIFF(Birthday, ‘1/1/2000’) / 365.25 as age from Members where date > 1/1/2000 select FirstName, LastName, SUBSTR(PhoneNumber,0,3) AS area_code from Members. SELECT UCASE(LastName) FROM Members select FirstName, LastName, DATEDIFF(NOW() ,Birthday) / 365.25 as age from Members
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.