1) List every member\'s name in the form last name comma first name (for example

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)

Members

Explanation / Answer

1.select * from emplyee order by lastname,firstname DESC;

2.select firstname,lastname,birthday from members where birthday<7/4/2005;

3.select firstname,lastname,birthday from members where birtday=11/11/2001';

4.select firstname,lastname (select birthday from members where birthday=1/1/2000)..se;

5.select firstname,lastname,areacode from members;

6.select ucase(lastname) from members;

7.select count (firstname,lastname) from members group by birthday;

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.