name John Smith Tiffany Brinkley John Lane Corrissa Farms Margaret Mary Methods and Tools in SW...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
name John Smith Tiffany Brinkley John Lane Corrissa Farms Margaret Mary Methods and Tools in SW Development Homework 2 phone (662) 555-1234 (901) 555-2345 (662) 555-9457 (662) 555-5289 (662) 555-4754 Contacts 1. Return contacts with the first name "John" 3. Return all the contacts address 103 Stark Rd 8492 Poplar Ave 4356 Main St 923 Research Blvd 241 Veterans Pkwy 2. Return the name and age of contacts ordered by age (oldest to youngest) zip 39759 38135 38668 39762 39759 4. Return contacts with the last name "Brinkley" 5. Return contacts between the ages of 20 and 30 (inclusive) 6. Return the name of the contacts that have the zip code of 39759 7. Update Corrissa Farm's age to 27 8. Insert another contact into the table (values are up to you) 9. Delete any contacts that live on a street containing "Poplar" anywhere in the address 10. Return a list of unique zip codes contained in the table age 22 Given the following database table, give the requested SQL query (not the results) that fulfills the prompt. Assume the table and column names are as listed (casing the same). 45 37 26 58 ▬▬▬▬▬ T name John Smith Tiffany Brinkley John Lane Corrissa Farms Margaret Mary Methods and Tools in SW Development Homework 2 phone (662) 555-1234 (901) 555-2345 (662) 555-9457 (662) 555-5289 (662) 555-4754 Contacts 1. Return contacts with the first name "John" 3. Return all the contacts address 103 Stark Rd 8492 Poplar Ave 4356 Main St 923 Research Blvd 241 Veterans Pkwy 2. Return the name and age of contacts ordered by age (oldest to youngest) zip 39759 38135 38668 39762 39759 4. Return contacts with the last name "Brinkley" 5. Return contacts between the ages of 20 and 30 (inclusive) 6. Return the name of the contacts that have the zip code of 39759 7. Update Corrissa Farm's age to 27 8. Insert another contact into the table (values are up to you) 9. Delete any contacts that live on a street containing "Poplar" anywhere in the address 10. Return a list of unique zip codes contained in the table age 22 Given the following database table, give the requested SQL query (not the results) that fulfills the prompt. Assume the table and column names are as listed (casing the same). 45 37 26 58 ▬▬▬▬▬ T
Expert Answer:
Answer rating: 100% (QA)
Certainly This homework assignment appears to be a set of SQL Structured Query Language exercises Be... View the full answer
Related Book For
Posted Date:
Students also viewed these programming questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...
-
1. Find the general indefinite integral (x +x)dx 2. Find the general indefinite integral (u +4)(2u +1)du 7/4 1+cos? 0 de cos 0 3. Evaluate the integral . 4. Evaluate the integral by making the given...
-
What is the identifying characteristic of the "other" category of revenues and expenses? Give an example of each.
-
The weight of a diesel engine is directly proportional to the compression ratio (W = kr) because extra metal must be used to strengthen the engine for the higher pressures. Examine the net specific...
-
The W14 \(\times 38\) column is made of A-36 steel. Determine the critical load if its bottom end is fixed supported and its top is free to move in plane about the strong axis and is pinned about the...
-
Financial Trends. You are a new city council person for the City of Scottsdale. Arizona. You are aware that several cities have been in the news recently for financial crises for which the council or...
-
Michael Jackson is performing his signature anti-gravity leanpose during his Smooth Criminal performance. He maintains his leanat 45 degrees relative to vertical. M.J.'s anthropometric profilesas...
-
Daniel Company uses a periodic inventory system. Data for 2015: beginning merchandise inventory (December 31, 2014), 2,000 units at $38; purchases, 8,000 units at $40; expenses (excluding income...
-
The resultant unbalanced force is minimum in reciprocating engines when the part of mass of reciprocating is balanced with rotating mass 2 (a) 3 (b) 2 (c) 3 (d) 3/5
-
The flat faced cam shown in figure rotates about 'O' at 60 rev/min. The roller follower has a mass of 0.8 kg. The vertical acceleration of m/s at 0 = 30. [Rounded follower is off upto one decimal...
-
A turbine, with an efficiency of 90%, operates on a Simple practical cycle as shown below. Steam enters the turbine at 6300 kPa and 350 C, and saturated mixture exhausts at 190 C. What is the actual...
-
a. data show that a material with an average grain size of 40 um has a yield strength of 150 MPA, whereas the same type of material with an average grain size of 2 um has a yield strength of 422 MPA....
-
(g) The characteristics curve a hydraulic pump is given as H = 10 -0.6Q -0.02Q where H is the pump head (in m), and Q is the flow rate (in L/s). This pump is used to deliver a discharge of 6.0L/s....
-
A high diver is performing a dive from a 10-meter platform. The diver jumps off the platform with an initial vertical velocity of 5 m/s in the direction shown in the figure below. Calculate how long...
-
Your company was hired as a subcontractor for a client's "Destiny" project and awarded two main work packages within that project. Your company refers to this project internally using the cost code...
-
Flicker, Inc., a closely held corporation, acquired a passive activity this year. Gross income from operations of the activity was $160,000. Operating expenses, not including depreciation, were...
-
Why are training programs one of the fi rst areas to be eliminated when an organizations budget must be cut?
-
Define the following categories: learners, stars, solid citizens, and deadwood. Discuss.
-
On September 30, 2009, a large, national automobile-leasing firm in Columbus, Ohio, hired Tom Holland as a mechanic. Tom, the only mechanic employed by the firm in Columbus, was to do routine...
-
The W14 \(\times 26\) structural A-36 steel member is used as a 20 -ft-long column that is assumed to be fixed at its top and fixed at its bottom. If the 15-kip load is applied at an eccentric...
-
The W14 \(\times 26\) structural A-36 steel member is used as a column that is assumed to be fixed at its top and pinned at its bottom. If the 15-kip load is applied at an eccentric distance of 10...
-
Determine the maximum eccentric load \(P\) the 2014-T6aluminum-alloy strut can support without causing it either to buckle or yield. The ends of the strut are pin connected. a $150 mm 150 mm 100 mm...
Study smarter with the SolutionInn App