Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a proper SQL query, that will return the age in years only. 'Gail','Abraham','1993-03-09' 'Alexandra','Allan','1995-12-26' 'Alison','Alsop','1992-12-19' 'Amanda','Anderson','1996-08-03' 'Amelia','Arnold','1998-06-02' 'Amy','Avery','1991-10-23' 'Andrea','Bailey','1991-02-03' 'Angela','Baker','1993-01-25' 'Anna','Ball','1990-07-16' 'Anne','Bell','1998-03-05' 'Audrey','Berry','1997-09-13' 'Ava','Black','1998-01-06'

Write a proper SQL query, that will return the age in years only.

'Gail','Abraham','1993-03-09' 'Alexandra','Allan','1995-12-26' 'Alison','Alsop','1992-12-19' 'Amanda','Anderson','1996-08-03' 'Amelia','Arnold','1998-06-02' 'Amy','Avery','1991-10-23' 'Andrea','Bailey','1991-02-03' 'Angela','Baker','1993-01-25' 'Anna','Ball','1990-07-16' 'Anne','Bell','1998-03-05' 'Audrey','Berry','1997-09-13' 'Ava','Black','1998-01-06' 'Bella','Blake','1990-11-12' 'Bernadette','Bond','1990-05-21' 'Carol','Bower','1993-07-23' 'Caroline','Brown','1997-08-17' 'Carolyn','Buckland','1994-07-05' 'Chloe','Burgess','1997-06-12' 'Claire','Butler','1998-04-06' 'Deirdre','Cameron','1995-12-10' 'Diana','Campbell','1992-03-11' 'Diane','Carr','1991-11-16' 'Donna','Chapman','1993-01-01' 'Dorothy','Churchill','1994-06-30' 'Elizabeth','Clark','1991-07-14' 'Ella','Clarkson','1995-11-05' 'Emily','Coleman','1993-04-18' 'Emma','Cornish','1998-05-16' 'Faith','Davidson','1991-07-24' 'Felicity','Davies','1998-01-14' 'Fiona','Dickens','1991-01-08' 'Gabrielle','Dowd','1990-06-12' 'Grace','Duncan','1990-01-11' 'Hannah','Dyer','1995-08-11' 'Heather','Edmunds','1997-01-31' 'Irene','Ellison','1998-06-30' 'Jan','Ferguson','1996-04-10' 'Jane','Fisher','1992-10-25' 'Jasmine','Forsyth','1991-06-19' 'Jennifer','Fraser','1993-12-24' 'Jessica','Gibson','1992-05-30' 'Joan','Gill','1997-10-27' 'Joanne','Glover','1991-10-11' 'Julia','Graham','1994-06-17' 'Karen','Grant','1998-07-19' 'Katherine','Gray','1996-08-06' 'Kimberly','Greene','1998-01-24' 'Kylie','Hamilton','1991-02-24' 'Lauren','Hardacre','1990-12-15' 'Leah','Harris','1996-11-25' 'Lillian','Hart','1998-01-13' 'Lily','Hemmings','1998-10-04' 'Lisa','Henderson','1995-07-29' 'Madeleine','Hill','1990-02-08' 'Maria','Hodges','1997-05-09' 'Mary','Howard','1990-07-11' 'Megan','Hudson','1998-03-10' 'Melanie','Hughes','1996-10-07' 'Michelle','Hunter','1994-11-09' 'Molly','Ince','1996-02-10' 'Natalie','Jackson','1992-06-02' 'Nicola','James','1995-07-09' 'Olivia','Johnston','1993-04-16' 'Penelope','Jones','1991-10-06' 'Pippa','Kelly','1995-07-24' 'Rachel','Kerr','1995-04-18' 'Rebecca','King','1992-04-22' 'Rose','Knox','1995-08-09' 'Ruth','Lambert','1993-06-04' 'Sally','Langdon','1998-12-30' 'Samantha','Lawrence','1993-02-20' 'Sarah','Lee','1991-09-05' 'Sonia','Lewis','1996-05-10' 'Sophie','Lyman','1991-03-26' 'Stephanie','MacDonald','1992-03-06' 'Sue','Mackay','1995-05-30' 'Theresa','Mackenzie','1998-01-02' 'Tracey','MacLeod','1995-01-11' 'Una','Manning','1992-03-15' 'Vanessa','Marshall','1998-01-27' 'Victoria','Martin','1992-04-01' 'Virginia','Mathis','1994-09-13' 'Wanda','May','1990-11-03' 'Wendy','McDonald','1998-12-10' 'Yvonne','McLean','1997-05-24' 'Zoe','McGrath','1993-10-04' 'Adam','Metcalfe','1990-11-02' 'Adrian','Miller','1998-12-06' 'Alan','Mills','1997-06-13' 'Alexander','Mitchell','1991-02-24' 'Andrew','Morgan','1992-06-20' 'Anthony','Morrison','1995-05-12' 'Austin','Murray','1991-12-31' 'Benjamin','Nash','1997-08-15' 'Blake','Newman','1994-01-26' 'Boris','Nolan','1993-11-08' 'Brandon','North','1993-12-08' 'Brian','Ogden','1996-01-23' 'Cameron','Oliver','1990-06-08' 'Carl','Paige','1995-09-23' 'Charles','Parr','1992-10-06' 'Christian','Parsons','1990-11-29' 'Christopher','Paterson','1990-02-24' 'Colin','Payne','1995-05-05' 'Connor','Peake','1996-08-06' 'Dan','Peters','1995-08-26' 'David','Piper','1996-05-09' 'Dominic','Poole','1997-04-15' 'Dylan','Powell','1990-10-31' 'Edward','Pullman','1995-01-26' 'Eric','Quinn','1994-09-29' 'Evan','Rampling','1990-06-21' 'Frank','Randall','1994-02-12' 'Gavin','Rees','1994-04-25' 'Gordon','Reid','1996-06-03' 'Harry','Roberts','1994-06-18' 'Ian','Robertson','1993-06-22' 'Isaac','Ross','1994-03-07' 'Jack','Russell','1991-07-10' 'Jacob','Rutherford','1995-01-04' 'Jake','Sanderson','1992-09-16' 'James','Scott','1997-11-06' 'Jason','Sharp','1998-03-03' 'Joe','Short','1996-06-11' 'John','Simpson','1991-01-07' 'Jonathan','Skinner','1993-03-26' 'Joseph','Slater','1995-11-24' 'Joshua','Smith','1990-03-12' 'Julian','Springer','1994-10-21' 'Justin','Stewart','1990-04-17' 'Keith','Sutherland','1993-12-12' 'Kevin','Taylor','1998-02-25' 'Leonard','Terry','1993-08-02' 'Liam','Thomson','1995-08-20' 'Lucas','Tucker','1992-03-30' 'Luke','Turner','1998-08-16' 'Matt','Underwood','1993-09-25' 'Max','Vance','1990-07-29' 'Michael','Vaughan','1991-05-11' 'Nathan','Walker','1998-03-27' 'Neil','Wallace','1997-03-12' 'Nicholas','Walsh','1993-04-28' 'Oliver','Watson','1992-02-24' 'Owen','Welch','1995-09-27' 'Paul','White','1990-05-21' 'Peter','Wilkins','1998-06-21' 'Phil','Wilson','1993-03-25' 'Piers','Wright','1998-07-10' 'Richard','Young','1990-07-15' 'Robert','Abraham','1997-10-31' 'Ryan','Allan','1990-11-28' 'Sam','Alsop','1997-05-19' 'Sean','Anderson','1998-12-30' 'Sebastian','Arnold','1993-09-26' 'Simon','Avery','1998-01-13' 'Stephen','Bailey','1996-07-30' 'Steven','Baker','1992-07-12' 'Stewart','Ball','1998-10-14' 'Thomas','Bell','1991-03-22' 'Tim','Berry','1992-12-02' 'Trevor','Black','1997-02-05' 'Victor','Blake','1991-02-26' 'Warren','Bond','1994-09-04' 'William','Bower','1993-07-28' 'Abraham','Brown','1990-01-09' 'Allan','Buckland','1994-04-19' 'Alsop','Burgess','1996-05-14' 'Anderson','Butler','1990-02-18' 'Arnold','Cameron','1994-05-24' 'Avery','Campbell','1997-05-23' 'Bailey','Carr','1992-10-13' 'Baker','Chapman','1991-09-18' 'Ball','Churchill','1998-12-15' 'Bell','Clark','1994-09-07' 'Berry','Clarkson','1993-09-01' 'Black','Coleman','1990-08-20' 'Blake','Cornish','1997-07-20' 'Bond','Davidson','1990-02-05' 'Bower','Davies','1993-05-26' 'Brown','Dickens','1990-12-08' 'Buckland','Dowd','1993-07-29' 'Burgess','Duncan','1993-03-09' 'Butler','Dyer','1995-10-22' 'Cameron','Edmunds','1993-07-11' 'Campbell','Ellison','1993-10-09' 'Carr','Ferguson','1991-09-01' 'Chapman','Fisher','1992-12-22' 'Churchill','Forsyth','1995-01-28' 'Clark','Fraser','1995-07-06' 'Clarkson','Gibson','1993-04-26' 'Coleman','Gill','1997-04-20' 'Cornish','Glover','1993-06-26' 'Davidson','Graham','1996-01-03' 'Davies','Grant','1993-08-24' 'Dickens','Gray','1997-04-27' 'Dowd','Greene','1997-04-12' 'Duncan','Hamilton','1995-08-05' 'Dyer','Hardacre','1996-07-04' 'Edmunds','Harris','1993-05-01' 'Ellison','Hart','1994-05-22' 'Ferguson','Hemmings','1998-04-24' 'Fisher','Henderson','1992-01-01' 'Forsyth','Hill','1998-10-20' 'Fraser','Hodges','1991-07-03' 'Gibson','Howard','1997-06-15' 'Gill','Hudson','1991-06-21' 'Glover','Hughes','1996-03-06' 'Graham','Hunter','1990-05-27' 'Grant','Ince','1995-08-14' 'Gray','Jackson','1993-02-06' 'Greene','James','1990-01-22' 'Hamilton','Johnston','1998-09-23' 'Hardacre','Jones','1992-12-02' 'Harris','Kelly','1994-08-18' 'Hart','Kerr','1990-12-21' 'Hemmings','King','1992-05-26' 'Henderson','Knox','1998-11-30' 'Hill','Lambert','1996-09-22' 'Hodges','Langdon','1998-10-19' 'Howard','Lawrence','1996-08-28' 'Hudson','Lee','1997-04-30' 'Hughes','Lewis','1991-11-20' 'Hunter','Lyman','1996-09-30' 'Ince','MacDonald','1997-03-12' 'Jackson','Mackay','1998-01-08' 'James','Mackenzie','1990-09-19' 'Johnston','MacLeod','1994-03-20' 'Jones','Manning','1996-11-29' 'Kelly','Marshall','1990-08-03' 'Kerr','Martin','1998-05-08' 'King','Mathis','1997-06-17' 'Knox','May','1997-04-26' 'Lambert','McDonald','1998-11-03' 'Langdon','McLean','1992-10-27' 'Lawrence','McGrath','1998-09-26' 'Lee','Metcalfe','1994-03-02' 'Lewis','Miller','1990-05-07' 'Lyman','Mills','1995-12-19' 'MacDonald','Mitchell','1996-05-06' 'Mackay','Morgan','1997-11-14' 'Mackenzie','Morrison','1997-06-25' 'MacLeod','Murray','1994-02-18' 'Manning','Nash','1993-10-13' 'Marshall','Newman','1997-02-08' 'Martin','Nolan','1993-10-11' 'Mathis','North','1990-03-13' 'May','Ogden','1990-09-11' 'McDonald','Oliver','1993-09-24' 'McLean','Paige','1995-08-21' 'McGrath','Parr','1991-05-29' 'Metcalfe','Parsons','1991-09-24' 'Miller','Paterson','1998-01-15' 'Mills','Payne','1993-02-09' 'Mitchell','Peake','1991-06-28' 'Morgan','Peters','1996-08-06' 'Morrison','Piper','1994-06-10' 'Murray','Poole','1992-11-05' 'Nash','Powell','1995-09-29' 'Newman','Pullman','1997-11-01' 'Nolan','Quinn','1993-10-14' 'North','Rampling','1997-09-11' 'Ogden','Randall','1992-04-17' 'Oliver','Rees','1992-02-29' 'Paige','Reid','1992-01-04' 'Parr','Roberts','1997-01-02' 'Parsons','Robertson','1998-04-20' 'Paterson','Ross','1997-03-20' 'Payne','Russell','1994-12-18' 'Peake','Rutherford','1990-08-26' 'Peters','Sanderson','1991-11-29' 'Piper','Scott','1997-01-27' 'Poole','Sharp','1993-09-30' 'Powell','Short','1995-11-24' 'Pullman','Simpson','1990-06-01' 'Quinn','Skinner','1990-10-08' 'Rampling','Slater','1991-05-30' 'Randall','Smith','1993-09-06' 'Rees','Springer','1994-10-05' 'Reid','Stewart','1997-07-16' 'Roberts','Sutherland','1991-04-06' 'Robertson','Taylor','1991-01-27' 'Ross','Terry','1991-08-29' 'Russell','Thomson','1990-07-18' 'Rutherford','Tucker','1990-09-08' 'Sanderson','Turner','1993-08-22' 'Scott','Underwood','1998-09-04' 'Sharp','Vance','1995-12-15' 'Short','Vaughan','1991-05-22' 'Simpson','Walker','1993-07-23' 'Skinner','Wallace','1991-11-21' 'Slater','Walsh','1998-11-22' 'Smith','Watson','1992-09-26' 'Springer','Welch','1996-07-22' 'Stewart','White','1992-07-12' 'Sutherland','Wilkins','1996-10-01' 'Taylor','Wilson','1991-12-06' 'Terry','Wright','1997-04-28' 'Thomson','Young','1995-01-21'

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Murach's SQL Server 2012 For Developers

Authors: Bryan Syverson, Joel Murach, Mike Murach

1st Edition

1890774693, 9781890774691

More Books

Students also viewed these Databases questions