For each artist who is currently in a band and is under 30 years old: *Return the artist’s full name, gender, date of birth (formatted like "06/12/2019"), and the name of the band they are in with date joined formatted like "July 18, 2022".Order the results by artist name* You will not get full points if you just say something like DOB > '1992-07-18' (hard coded thirty tears ago today). The query would not age well! Tables and values are in the picture attached. assignment8.sql x101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354/* Create all tables. Order matters due to foreign keys. */CREATE TABLE p_artist (id INT AUTO INCREMENT,fname VARCHAR (30) NOT NULL,1name VARCHAR (30),dob DATE,hometown VARCHAR (40),gender CHAR (1),PRIMARY KEY (id)L) ENGINE = innodb;CREATE TABLE p_band (1id INT AUTO INCREMENT,title VARCHAR (50) NOT NULL,year_formed YEAR,PRIMARY KEY (id)-) ENGINE = innodb;CREATE TABLE p member (artist_id INT NOT NULL,band_id INT NOT NULL,pardjoined date DATE,leave_date DATE,FOREIGN KEY (artist_id) REFERENCES p_artist (id),FOREIGN KEY (band_id) REFERENCES p_band (id)-) ENGINE = innodb;CREATE TABLE p_album (id INT not null,pub_year YEAR,title VARCHAR (50),publisher VARCHAR (50),format CHAR (1),band_id INT NOT NULL,PRIMARY KEY (id),FOREIGN KEY (band_id) REFERENCES p_band (id)-) ENGINE = innodb;CREATE TABLE p song (album_id INT NOT NULL,name VARCHAR(30) NOT NULL,length TIME,FOREIGN KEY (album_id) REFERENCES p_album (id)-) ENGINE = innodb;

CREATE TABLE artist (id INT NOT NULL,fname VARCHAR(30) NOT NULL,lname VARCHAR(30),dob DATE,hometown…

Answered: Return the artist’s full name, gender,…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

For each artist who is currently in a band and is under 30 years old: *

Return the artist’s full name, gender, date of birth (formatted like "06/12/2019"), and the name of the band they are in with date joined formatted like "July 18, 2022".

Order the results by artist name

* You will not get full points if you just say something like DOB > '1992-07-18' (hard coded thirty tears ago today). The query would not age well!

Tables and values are in the picture attached.

assignment8.sql x
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
/* Create all tables. Order matters due to foreign keys. */
CREATE TABLE p_artist (
id INT AUTO INCREMENT,
fname VARCHAR (30) NOT NULL,
1name VARCHAR (30),
dob DATE,
hometown VARCHAR (40),
gender CHAR (1),
PRIMARY KEY (id)
L) ENGINE = innodb;
CREATE TABLE p_band (1
id INT AUTO INCREMENT,
title VARCHAR (50) NOT NULL,
year_formed YEAR,
PRIMARY KEY (id)
-) ENGINE = innodb;
CREATE TABLE p member (
artist_id INT NOT NULL,
band_id INT NOT NULL,
pard
joined date DATE,
leave_date DATE,
FOREIGN KEY (artist_id) REFERENCES p_artist (id),
FOREIGN KEY (band_id) REFERENCES p_band (id)
-) ENGINE = innodb;
CREATE TABLE p_album (
id INT not null,
pub_year YEAR,
title VARCHAR (50),
publisher VARCHAR (50),
format CHAR (1),
band_id INT NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (band_id) REFERENCES p_band (id)
-) ENGINE = innodb;
CREATE TABLE p song (
album_id INT NOT NULL,
name VARCHAR(30) NOT NULL,
length TIME,
FOREIGN KEY (album_id) REFERENCES p_album (id)
-) ENGINE = innodb;

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions