CREATE TABLE CLIENTS e_mail name surn1 surn2 birthdate phone address DNI ; VARCHAR2 (100), VARCHAR2 (80),...

  

Transcribed Image Text:

CREATE TABLE CLIENTS e_mail name surn1 surn2 birthdate phone address DNI ; VARCHAR2 (100), VARCHAR2 (80), VARCHAR2 (80) VARCHAR2 (80), when RFID 1 CONSTRAINT PK_CLIENTS PRIMARY KEY (e_mail), CONSTRAINT UK_CLIENTS UNIQUE (DNI) I ); DATE, NUMBER (9), VARCHAR2 (100), VARCHAR2 (8), CREATE TABLE ATTENDANCES ( client performer VARCHAR2 (100), VARCHAR2 (100), DATE, VARCHAR2 (120) NOT NULL, DATE, purchase CONSTRAINT PK_ATTENDANCES PRIMARY KEY (client, performer, when), CONSTRAINT UK_ATTENDANCES UNIQUE (performer, when, RFID), CONSTRAINT FK_ATTENDANCES1 FOREIGN KEY (performer, when) REFERENCES CONCERTS ON DELETE CASCADE, CONSTRAINT FK_ATTENDANCES2 FOREIGN KEY (client) REFERENCES CLIENTS SQL> select C.e_mail, concat(C.name, C.surn1) name, ROUND ((SYSDATE C.birthdate)/365, 1) age from clients C join attendances A on C.e_mail-A.client where e_mail not in (select e_mail from bannedfans) and A.client in (select A.client, count (A.perform er) num_attend from attendances A where A. performer-melopack.get_current_performer() group by A.client having count (A.perform er)>1) and A.performer-melopack.get_current_performer(); select C.e_mail, concat(C.name, C.surn1) name, ROUND ((SYSDATE C.birthdate)/365, 1) age from clients C join attendances A on C.e_mail=A.client where e_mail not in (select e_mail from bannedfans) and A.client in (select A.client, count (A. performer) n um_attend from attendances A where A.performer-melopack.get_current_performer () group by A.client having count (A. performer) >1 ) and A. performer=melopack.get_current_performer () ERROR at line 1: ORA-00913: too many values CREATE TABLE CLIENTS e_mail name surn1 surn2 birthdate phone address DNI ; VARCHAR2 (100), VARCHAR2 (80), VARCHAR2 (80) VARCHAR2 (80), when RFID 1 CONSTRAINT PK_CLIENTS PRIMARY KEY (e_mail), CONSTRAINT UK_CLIENTS UNIQUE (DNI) I ); DATE, NUMBER (9), VARCHAR2 (100), VARCHAR2 (8), CREATE TABLE ATTENDANCES ( client performer VARCHAR2 (100), VARCHAR2 (100), DATE, VARCHAR2 (120) NOT NULL, DATE, purchase CONSTRAINT PK_ATTENDANCES PRIMARY KEY (client, performer, when), CONSTRAINT UK_ATTENDANCES UNIQUE (performer, when, RFID), CONSTRAINT FK_ATTENDANCES1 FOREIGN KEY (performer, when) REFERENCES CONCERTS ON DELETE CASCADE, CONSTRAINT FK_ATTENDANCES2 FOREIGN KEY (client) REFERENCES CLIENTS SQL> select C.e_mail, concat(C.name, C.surn1) name, ROUND ((SYSDATE C.birthdate)/365, 1) age from clients C join attendances A on C.e_mail-A.client where e_mail not in (select e_mail from bannedfans) and A.client in (select A.client, count (A.perform er) num_attend from attendances A where A. performer-melopack.get_current_performer() group by A.client having count (A.perform er)>1) and A.performer-melopack.get_current_performer(); select C.e_mail, concat(C.name, C.surn1) name, ROUND ((SYSDATE C.birthdate)/365, 1) age from clients C join attendances A on C.e_mail=A.client where e_mail not in (select e_mail from bannedfans) and A.client in (select A.client, count (A. performer) n um_attend from attendances A where A.performer-melopack.get_current_performer () group by A.client having count (A. performer) >1 ) and A. performer=melopack.get_current_performer () ERROR at line 1: ORA-00913: too many values

Answer rating: 100% (QA)

It looks like you are attempting to execute a SQL statement that joins two tables CLIENTS and ATTENDANCES but are facing an ORA00913 too many values e... View the full answer