CREATE TABLE CLIENTS e_mail name surn1 surn2 birthdate phone address DNI ; VARCHAR2 (100), VARCHAR2 (80),...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Posted Date:
Students also viewed these databases questions
-
How has the real estate industry evolved or changed throughout time? Write a critically discussion.
-
optimize the queries below by indexing and clustering to lower the amounts of consistent gets. The tables related to the queries are below. I want to be able to create clusters of the tables trucks...
-
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...
-
Arrange the following events in the correct temporal sequence during eukaryotic cell division, starting with the earliest: (a) condensation of the chromosomes, (b) Movement of chromosomes to the...
-
Calculate the heat transfer for the process described in Problem 4.55. Consider a piston cylinder with 0.5 kg of R-134a as saturated vapor at -10C. It is now compressed to a pressure of 500 kPa in a...
-
Why is it important that PAs have high-quality financial statement audits?
-
A company that processes health claims maintains three centers. Software was installed so they could monitor non-business internet usage by their employees. Initially, six employees were randomly...
-
Using the corporate tax rate schedule given in Table, perform the following: a. Calculate the tax liability, after-tax earnings, and average tax rates for the following levels of corporate earnings...
-
Preparing a Job Order Cost Sheet Riverwood Accounting Company has the following account in its cost records: Direct labor Work in Process-Jones Audit 140,000 Services completed 295,771 Project...
-
Air containing 1.6 vol% sulfur dioxide is scrubbed with pure water in a packed column of 1.5-m2 cross-sectional area and 3.5-m height packed with no. 2 plastic Super Intalox saddles, at a pressure of...
-
13 18 points Skipped eBook Print References You want to create a portfolio equally as risky as the market, and you have $500,000 to invest. Information about the possible investments is given below:...
-
The graph of a 9th-degree polynomial with real coefficients is given below. Answer the following questions about the polynomial, by looking at its graph. Assume all real zeros here have multiplicity...
-
Why do you think investors need to know operating income when they have net income? What is the most significant information that your Income Statement is providing you in general and more...
-
Two radar stations located 20 miles apart detect an aircraft between them. The angle of elevation measured by the 1st station is 35, whereas the angle of elevation measured by the 2nd, is 15....
-
A combination lock opens with the correct three-digit code. Each wheel rotates through the digits 1 to 8. Suppose each digit can be used only once in a code. How many different codes are possible...
-
You are the owner of a middle-sized Company (with the annual turnover of Euro 5 min) and came to the meeting with your lending bank with the intention to increase your loan portfolio. At the meeting...
-
A visitor of the casino has initial wealth W and a vN-M utility function u(w) for wealth satisfying u(w) > 0 for all w R. For a xed payment to the casino, he can play an electronic pinball machine...
-
What will be the final value of DI after executing the following piece of code? Execute the instructions dependently one after another. CLD MOU CX,OFOH MOU AX.02874H MOU DI,01000H MOU ES, DI SUB...
-
Create a simple E-R model depicting entities and relationship lines for data scenario. Every employee in a company is assigned to one department. Every department can contain many employees.
-
Which of the following is not a valid constraint type? a. PRIMARY KEYS b. UNIQUE c. CHECK d. FOREIGN KEY
-
Which of the following is an object privilege? a. CREATE SESSION b. DROP USER c. INSERT ANY TABLE d. UPDATE
-
T/F: BOs are internally stable and externally adaptable.
-
T/F: BOs is the middle layer of stability model.
-
T/F: BOs are semi-tangible and mostly conceptual.
Study smarter with the SolutionInn App