Give everyones last name in all uppercase

Assignment Help Computer Engineering

Reference no: EM132159023

USE SQL Query THAT WORKS WITH ACCESS.(please test it out before posting the answers up)

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**
FirstName	LastName	PhoneNumber	Birthday
Anna Maria	Castanza	828-555-8731	3/3/1996
Astoria	Barton	336-555-9301	11/11/2001
Fern	Azzam	704-555-3910	3/19/2000
Jamal	Freedman	336-555-4529	12/4/1982
Joey	Dinardo	336-555-9902	5/12/1975
John	Smith	336-555-1212	5/21/1982
Jonas	Brothers	828-555-3492	3/21/1974
Juanita	Cohen	980-555-0802	4/1/1957
Judson	Parker	704-555-9020	2/23/2001
Marina	Smith	202-555-9431	5/6/2007
Mary	Lamb	336-555-0188	1/24/1999
N'Ketcha	Williams	919-555-0011	7/4/1980
Quintin	Frieze	910-555-2454	3/9/1998
Terrance	Ali	919-555-2924	11/4/2003

Reference no: EM132159023

Questions Cloud

Probability of 5 automobiles arriving in an hour : According to this data what is the probability of 5 automobiles arriving in an hour on a weekday?

What is the probability that fifteen or fewer tires : What is the probability that fifteen or fewer tires will last more than 75,000 miles?

Determine which distribution needs to be used and why : Construct a 98% confidence interval for the population mean- determine which distribution needs to be used and why

Suggests that their heights are normally distributed : A random variable Y is continuous with a normal distribution with a mean of 50 and a standard deviation of 5. What is P(Y >= 62.5)

Give everyones last name in all uppercase : List the first name, last name, and birthday of everyone whose birthday is after July 4, 2005.

Implement multidimensional arrays in your program : Discuss where two and multidimensional arrays are useful. Give at least one example where you would implement multidimensional arrays in your program.

Effect the new tax laws are having on donations : Present a hypothesis and a null hypothesis, and evaluate them. What can the director conclude about the effect the new tax laws are having on donations?

Describe a research question that requires a paired-samples : Describe a research question that requires a paired-samples t test and explain why this particular type of t test is the best way to answer the research

What is the z-test : What is the z-test? State in what circumstance you would perform a z test and give an example of a study for which the z-test would be appropriate.

User Account

All Pages