go --products table create a table CREATE TABLE Products ( ProductID INTEGER PRIMARY KEY, ModelNumber INTEGER, ModelName TEXT NOT NULL, ProductImage IMAGE, UnitCost INTEGER, Description TEXT NOT NULL, FOREIGN KEY(CategoryID) REFERENCES Categ ); Foreign key 'FK_Products_a42a460b5f04ceb87f28' references invalid column 'CategoryID' in referencing table 'Products'. -- insert some values INSERT INTO products VALUES (6 108 'Chrome' ge 'Book 3)

go --products table create a table CREATE TABLE Products ( ProductID INTEGER PRIMARY KEY, ModelNumber INTEGER, ModelName TEXT NOT NULL, ProductImage IMAGE, UnitCost INTEGER, Description TEXT NOT NULL, FOREIGN KEY(CategoryID) REFERENCES Categ ); Foreign key 'FK_Products_a42a460b5f04ceb87f28' references invalid column 'CategoryID' in referencing table 'Products'. -- insert some values INSERT INTO products VALUES (6 108 'Chrome' ge 'Book 3)

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers

Section: Chapter Questions

Problem 8EYW

See similar textbooks

Similar questions

LAB - Select horses with logical operators The Horse table has the following columns: • ID integer, primary key • RegisteredName - variable-length string • Breed - variable-length string • Height-decimal number • BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.
CREATE TABLE Employee( Eid INT PRIMARY KEY, E_name VARCHAR(20), E_Age INT CHECK (E_Age between 18 and 60), ECity VARCHAR(20), E_Street VARCHAR(20), E_House# INT, E_Basic_Salary DECIMAL(18,2), E_Bonus DECIMAL(18,2), E_Rank VARCHAR(20) CHECK (E_Rank IN('Manager','Develper','Admin')), E_Department VARCHAR(20) DEFAULT 'CS' CHECK (E_Department IN ('HR','CS','IT','Labour'))); Create Table Porjects: CREATE TABLE Project1( p_id INT , pName VARCHAR(20), p_bonus DECIMAL(18,2), duration_in_months INT, Eid INT, PRIMARY KEY(p_id,Eid), FOREIGN KEY(Eid) REFERENCES Employee(Eid)); now the question is... Display Total expenditures of company. (total expenditures = basic salary + bonus of employee + all project bonus) Display names of projects in which ‘Ahmar’ is Display total project bonus of ‘Danish’. Display total expenditures of only those departments whose total expenditures are more than 1 Million. (total expenditures = sum of basic salary of all employees of that…
1- Display contact First name and contact Last name for customers after sorting the customersby their contact Last name in ascending order.2- selects the order line items (orderNumber, orderlinenumber) from the “orderdetails” table.Also, display the subtotal (quantityOrdered * priceEach) for each line item and sorts the resultset based on the subtotal descending .3- Display unique last names from employees table ordered by last name.4- Display customerNumber, customerName and creditLimit for getting the top five customerswho have the highest creditLimit.5- Find customer Name, customer country, sales representative employee number fromcustomers who do not have a sales representative.6- For each order status, display status and count of orders have this status.7- For Each order number in order details table, Display order number, sum of quantity ordered(itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition “total”greater than 1000.8- Display product code, product…
Modify the Job_class column of the EMPLOYEES table so that it allows storing a maximum width of two characters.
The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020. -- Your SELECT statement goes hereSELECT *FROM HorseWHERE (Height >= '15.0' AND Height <= '16.0') OR BirthDate >= '2020-01-01';
PLZ help with the followng: List all painting titles with price greater than 5000$. How many paintings does ‘Ross Georgette’ have? Find the title of paintings that displayed on ‘L. R. Gilliam’ gallery. CREATE TABLE GALLERY (GAL_NUM char(4),GAL_OWNER varchar(35),GAL_AREACODE char(3),GAL_PHONE char(8),GAL_RATE number);INSERT INTO GALLERY VALUES('5','L. R. Gilliam','901','123-4456',0.37);INSERT INTO GALLERY VALUES('6','G. G. Waters','405','353-2243',0.45 );INSERT INTO GALLERY VALUES('1','N. D. Cosner','203','123-9956',0.67);INSERT INTO GALLERY VALUES('2','S. H. Artwork','415','154-3243',0.30); /* -- */ CREATE TABLE PAINTER (PTR_NUM char(4),PTR_LASTNAME varchar(15) NOT NULL,PTR_FIRSTNAME varchar(15) NOT NULL,PTR_AREACODE char(3),PTR_PHONE char(8));INSERT INTO PAINTER VALUES('123','Ross','Georgette','901','885-4567');INSERT INTO PAINTER VALUES('126','Itero','Julio','901','346-1112');INSERT INTO PAINTER VALUES('127','Geoff','George','615','221-4456'); /* -- */ CREATE TABLE…
he Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.
create table patients ( patient_id VARCHAR(255),name VARCHAR(255),insurance DECIMAL(15,2),date_admitted DATE,date_checked_out DATE,PRIMARY KEY(patient_id));INSERT INTO patients (ID , name , insurance , date_admitted , date_checked_out) values (2 , 'Ali' , '22.2' , '2/1/2020' , '3/1/2020')SELECT * FROM table patients create table doctor (doctor_id VARCHAR(255),name VARCHAR(255),specialization VARCHAR(255),PRIMARY KEY (doctor_id) ); create table test (test_id VARCHAR(255),test_name VARCHAR(255),test_date DATE,test_time TIME,result VARCHAR(255),PRIMARY KEY(test_id)); create table doctor_patient( patient_id VARCHAR(255), doctor_id VARCHAR(255),PRIMARY KEY(patient_id),FOREIGN KEY(doctor_id) REFERENCES doctor(doctor_id) ); create table test_log (test_log_id varchar(255),patient_id VARCHAR(255),test_id VARCHAR(255),doctor_id VARCHAR(255),comments VARCHAR(255),PRIMARY KEY(test_log_id),FOREIGN KEY(test_id) REFERENCES test(test_id),FOREIGN KEY(patient_id) REFERENCES…
create table patients ( patient_id VARCHAR(255),name VARCHAR(255),insurance DECIMAL(15,2),date_admitted DATE,date_checked_out DATE,PRIMARY KEY(patient_id));INSERT INTO patients (ID , name , insurance , date_admitted , date_checked_out) values (2 , 'Ali' , '22.2' , '2/1/2020' , '3/1/2020')SELECT * FROM table patients create table doctor (doctor_id VARCHAR(255),name VARCHAR(255),specialization VARCHAR(255),PRIMARY KEY (doctor_id) ); create table test (test_id VARCHAR(255),test_name VARCHAR(255),test_date DATE,test_time TIME,result VARCHAR(255),PRIMARY KEY(test_id)); create table doctor_patient( patient_id VARCHAR(255), doctor_id VARCHAR(255),PRIMARY KEY(patient_id),FOREIGN KEY(doctor_id) REFERENCES doctor(doctor_id) ); create table test_log (test_log_id varchar(255),patient_id VARCHAR(255),test_id VARCHAR(255),doctor_id VARCHAR(255),comments VARCHAR(255),PRIMARY KEY(test_log_id),FOREIGN KEY(test_id) REFERENCES test(test_id),FOREIGN KEY(patient_id) REFERENCES…
After composing the code for the " Create Horse Table with Constraints" I'm still not getting an output CREATE TABLE Horse ( ID SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, RegisteredName VARCHAR(15) NOT NULL, Breed VARCHAR(20) CHECK (Breed IN ('Egyptian Arab', 'Holsteiner', 'Quarter Horse', 'Paint', 'Saddlebred')), Height DECIMAL(3,1) CHECK (Height between 10.0 AND 20.0), BirthDate DATE CHECK (BirthDate >= '2015-01-01'));
The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Delete the following rows: Horse with ID 5. All horses with breed Holsteiner or Paint. All horses born before March 13, 2013.
CREATE TABLE TEAMS (TEAMNO INTEGER NOT NULL, PLAYERNO INTEGER NOT NULL, DIVISION CHAR(6) NOT NULL, PRIMARY KEY (TEAMNO) ); CREATE TABLE PENALTIES (PAYMENTNO INTEGER NOT NULL, PLAYERNO INTEGER NOT NULL, PAYMENT_DATE DATE NOT NULL, AMOUNT DECIMAL(7,2) NOT NULL, PRIMARY KEY (PAYMENTNO) ); INSERT INTO TEAMS VALUES(1, 6, 'first'); INSERT INTO TEAMS VALUES (2, 27, 'second'); INSERT INTO PENALTIES VALUES(1, 6, '1980-12-08',100); INSERT INTO PENALTIES VALUES (2, 44, '1981-05-05', 75); INSERT INTO PENALTIES VALUES (3, 27, '1983-09-10',100); INSERT INTO PENALTIES VALUES (4,104, '1984-12-08', 50); INSERT INTO PENALTIES VALUES (5, 44, '1980-12-08', 25); INSERT INTO PENALTIES VALUES (6, 8, '1980-12-08', 25); INSERT INTO PENALTIES VALUES (7, 44, '1982-12-30', 30); INSERT INTO PENALTIES VALUES (8, 27, '1984-11-12', 75); Add a new column called Founded of type date to the TEAMS table after the TEAMNO. Add a new column called Paid of type char (1) to the PENALTIES table.