Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
bc160401882
CREATE DATABASE BC160401882 CREATE TABLE Coustomer( custID smallint constraint cID primary key, cNAME Varchar(25), cADDRESS Text, cEMAIL Text, ); SELECT*FROM Coustomer CREATE TABLE Category( catID smallint constraint catID primary key, catNAME Varchar(25), initalRate int, ); SELECT*FROM Category CREATE TABLE Services( serID smallint constraint serID primary key, serTitle Varchar(50), setDescription Varchar(50), serCharges int, ); SELECT*FROM Services CREATE TABLE Food_item( itemID smallint constraint itemID primary key, itemName Varchar(25), itemDescription Varchar(50), ); SELECT*FROM Food_item CREATE TABLE Menu( menuID smallint constraint menuID primary key, no.Of.serving int, Quantity int, no.Ofitems int, ); SELECT*FROM Menu CREATE TABLE Venue( location Varchar(50), city Varchar(50), capacity Varchar(50), description Varchar(50), ); SELECT*FROM Venue CREATE TABLE Event( eID smallint constraint eID primary key, Date datetime, timeSlot time, ); SELECT*FROM Event INSERT INTO Event VALUES('001','07/15/2018','12:00') SELECT*FROM Event
run
|
edit
|
history
|
help
0
Window Functions - ROW_NUMBER()
sssss
TRANSACTIONS
Task_2_Final
20181CSE0534
Student
Second Query
[SQLS]-Split and update a column
tFuncionario
Exam_2_Final