how to check if sql query is correct online

Comment

0

CREATE TABLE orchestra(
ORCHESTRA_ID int(15),
ORCHESTRA_NAME varchar(30),
ORCHESTRA_LOC varchar(15),
ORCHESTRA_HOURS int(10)
);

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Share

Link to this answer
Share Copy Link

Contributed on Nov 19 2021

Bloody Batfish

0 Answers Avg Quality 2/10

sql query checker

Comment

1

CREATE TABLE employee

   ( employee_id VARCHAR(20),

    Name VARCHAR (20),

    Address VARCHAR (20),

    Mobile_no  SMALLINT);

Popularity 10/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Share

Link to this answer
Share Copy Link

Contributed on May 29 2021

Real Rattlesnake

0 Answers Avg Quality 2/10

sql statement checker corrector

Comment

0

select * from movie where mname like'%r' and where category='family';

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Share

Link to this answer
Share Copy Link

Contributed on Sep 20 2021

Glorious Grivet

0 Answers Avg Quality 2/10

sql statement checker corrector

Comment

0

CREATE TABLE Provider (ProviderID CHAR(6) not null, FirstName VARCHAR(24) not null,
                       LastName VARCHAR(64) not null, PRIMARY KEY (ProviderID) );
INSERT INTO Provider (ProviderID, LastName, FirstName) 
VALUES ('123456', 'Spock', 'Ben');
SELECT*FROM Provider;
ALTER TABLE Provider ADD COLUMN HireDate date;
UPDATE Provider SET FirstName = 'Ben' WHERE ProviderID = '123456';
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123457', 'Schweitzer', 'Albert', '1990-05-09');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123458', 'Shepherd', 'Derek', '2005-03-27');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123459', 'Sloan', 'Mark', '2005-03-27');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123460', 'Thomas', 'Brett', '2020-01-15');
SELECT*FROM Provider;
SELECT LastName, HireDate FROM Provider;
SELECT DISTINCT HireDate FROM Provider;
SELECT LastName, FirstName FROM Provider WHERE ProviderID = '123456';
SELECT ProviderID, LastName FROM Provider WHERE Hiredate >= '2010-01-01';
SELECT*FROM Provider WHERE HireDate BETWEEN '1990-01-01'
AND '2020-03-31';
SELECT ProviderID, LastName, FirstName FROM Provider WHERE HireDate is NULL
ALTER TABLE Provider ADD COLUMN Salary float;
UPDATE Provider SET Salary = 65000 WHERE ProviderID = '123456';

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Share

Link to this answer
Share Copy Link

Contributed on Dec 21 2021

Plain Puffin

0 Answers Avg Quality 2/10

sql statement checker corrector

Comment

0

CREATE TABLE Provider (ProviderID CHAR(6) not null, FirstName VARCHAR(24) not null,
                       LastName VARCHAR(64) not null, PRIMARY KEY (ProviderID) );
INSERT INTO Provider (ProviderID, LastName, FirstName) 
VALUES ('123456', 'Spock', 'Ben');
SELECT*FROM Provider;
ALTER TABLE Provider ADD COLUMN HireDate date;
UPDATE Provider SET FirstName = 'Ben' WHERE ProviderID = '123456';
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123457', 'Schweitzer', 'Albert', '1990-05-09');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123458', 'Shepherd', 'Derek', '2005-03-27');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123459', 'Sloan', 'Mark', '2005-03-27');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123460', 'Thomas', 'Brett', '2020-01-15');
SELECT*FROM Provider;
SELECT LastName, HireDate FROM Provider;
SELECT DISTINCT HireDate FROM Provider;
SELECT LastName, FirstName FROM Provider WHERE ProviderID = '123456';
SELECT ProviderID, LastName FROM Provider WHERE Hiredate >= '2010-01-01';
SELECT*FROM Provider WHERE HireDate BETWEEN '1990-01-01'
AND '2020-03-31';
SELECT ProviderID, LastName, FirstName FROM Provider WHERE HireDate is NULL
ALTER TABLE Provider ADD COLUMN Salary float;
UPDATE Provider SET Salary = 65000 WHERE ProviderID = '123456';

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Share

Link to this answer
Share Copy Link

Contributed on Dec 21 2021

Plain Puffin

0 Answers Avg Quality 2/10

sql statement checker corrector

Comment

0

CREATE TABLE Provider (ProviderID CHAR(6) not null, FirstName VARCHAR(24) not null,
                       LastName VARCHAR(64) not null, PRIMARY KEY (ProviderID) );
INSERT INTO Provider (ProviderID, LastName, FirstName) 
VALUES ('123456', 'Spock', 'Ben');
SELECT*FROM Provider;
ALTER TABLE Provider ADD COLUMN HireDate date;
UPDATE Provider SET FirstName = 'Ben' WHERE ProviderID = '123456';
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123457', 'Schweitzer', 'Albert', '1990-05-09');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123458', 'Shepherd', 'Derek', '2005-03-27');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123459', 'Sloan', 'Mark', '2005-03-27');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123460', 'Thomas', 'Brett', '2020-01-15');
SELECT*FROM Provider;
SELECT LastName, HireDate FROM Provider;
SELECT DISTINCT HireDate FROM Provider;
SELECT LastName, FirstName FROM Provider WHERE ProviderID = '123456';
SELECT ProviderID, LastName FROM Provider WHERE Hiredate >= '2010-01-01';
SELECT*FROM Provider WHERE HireDate BETWEEN '1990-01-01'
AND '2020-03-31';
SELECT ProviderID, LastName, FirstName FROM Provider WHERE HireDate is NULL
ALTER TABLE Provider ADD COLUMN Salary float;
UPDATE Provider SET Salary = 65000 WHERE ProviderID = '123456';
UPDATE Provider SET Salary = 9500 WHERE ProviderID = '123457';

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Share

Link to this answer
Share Copy Link

Contributed on Dec 21 2021

Plain Puffin

0 Answers Avg Quality 2/10

sql statement checker corrector

Comment

0

CREATE TABLE Provider (ProviderID CHAR(6) not null, FirstName VARCHAR(24) not null,
                       LastName VARCHAR(64) not null, PRIMARY KEY (ProviderID) );
INSERT INTO Provider (ProviderID, LastName, FirstName) 
VALUES ('123456', 'Spock', 'Ben');
SELECT*FROM Provider;
ALTER TABLE Provider ADD COLUMN HireDate date;
UPDATE Provider SET FirstName = 'Ben' WHERE ProviderID = '123456';
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123457', 'Schweitzer', 'Albert', '1990-05-09');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123458', 'Shepherd', 'Derek', '2005-03-27');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123459', 'Sloan', 'Mark', '2005-03-27');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123460', 'Thomas', 'Brett', '2020-01-15');
SELECT*FROM Provider;
SELECT LastName, HireDate FROM Provider;
SELECT DISTINCT HireDate FROM Provider;
SELECT LastName, FirstName FROM Provider WHERE ProviderID = '123456';
SELECT ProviderID, LastName FROM Provider WHERE Hiredate >= '2010-01-01';
SELECT*FROM Provider WHERE HireDate BETWEEN '1990-01-01'
AND '2020-03-31';
SELECT ProviderID, LastName, FirstName FROM Provider WHERE HireDate is NULL
ALTER TABLE Provider ADD COLUMN Salary float;
UPDATE Provider SET Salary = 65000 WHERE ProviderID = '123456';
UPDATE Provider SET Salary = 9500 WHERE ProviderID = '123457';

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Share

Link to this answer
Share Copy Link

Contributed on Dec 21 2021

Plain Puffin

0 Answers Avg Quality 2/10

sql statement checker corrector

Comment

0

CREATE TABLE Provider (ProviderID CHAR(6) not null, FirstName VARCHAR(24) not null,
                       LastName VARCHAR(64) not null, PRIMARY KEY (ProviderID) );
INSERT INTO Provider (ProviderID, LastName, FirstName) 
VALUES ('123456', 'Spock', 'Ben');
SELECT*FROM Provider;
ALTER TABLE Provider ADD COLUMN HireDate date;
UPDATE Provider SET FirstName = 'Ben' WHERE ProviderID = '123456';
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123457', 'Schweitzer', 'Albert', '1990-05-09');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123458', 'Shepherd', 'Derek', '2005-03-27');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123459', 'Sloan', 'Mark', '2005-03-27');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123460', 'Thomas', 'Brett', '2020-01-15');
SELECT*FROM Provider;
SELECT LastName, HireDate FROM Provider;
SELECT DISTINCT HireDate FROM Provider;
SELECT LastName, FirstName FROM Provider WHERE ProviderID = '123456';
SELECT ProviderID, LastName FROM Provider WHERE Hiredate >= '2010-01-01';
SELECT*FROM Provider WHERE HireDate BETWEEN '1990-01-01'
AND '2020-03-31';
SELECT ProviderID, LastName, FirstName FROM Provider WHERE HireDate is NULL
ALTER TABLE Provider ADD COLUMN Salary float;
UPDATE Provider SET Salary = 65000 WHERE ProviderID = '123456';
UPDATE Provider SET Salary = 9500 WHERE ProviderID = '123457';
UPDATE Provider SET Salary = 142000 WHERE ProviderID = '123458';
UPDATE Provider SET Salary = 130000 WHERE ProviderID = '123459';
UPDATE Provider SET Salary = 160000 WHERE ProviderID = '123460';

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Share

Link to this answer
Share Copy Link

Contributed on Dec 21 2021

Plain Puffin

0 Answers Avg Quality 2/10

sql statement checker corrector

Comment

0

CREATE TABLE Provider (ProviderID CHAR(6) not null, FirstName VARCHAR(24) not null,
                       LastName VARCHAR(64) not null, PRIMARY KEY (ProviderID) );
INSERT INTO Provider (ProviderID, LastName, FirstName) 
VALUES ('123456', 'Spock', 'Ben');
SELECT*FROM Provider;
ALTER TABLE Provider ADD COLUMN HireDate date;
UPDATE Provider SET FirstName = 'Ben' WHERE ProviderID = '123456';
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123457', 'Schweitzer', 'Albert', '1990-05-09');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123458', 'Shepherd', 'Derek', '2005-03-27');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123459', 'Sloan', 'Mark', '2005-03-27');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123460', 'Thomas', 'Brett', '2020-01-15');
SELECT*FROM Provider;
SELECT LastName, HireDate FROM Provider;
SELECT DISTINCT HireDate FROM Provider;
SELECT LastName, FirstName FROM Provider WHERE ProviderID = '123456';
SELECT ProviderID, LastName FROM Provider WHERE Hiredate >= '2010-01-01';
SELECT*FROM Provider WHERE HireDate BETWEEN '1990-01-01'
AND '2020-03-31';
SELECT ProviderID, LastName, FirstName FROM Provider WHERE HireDate is NULL
ALTER TABLE Provider ADD COLUMN Salary float;
UPDATE Provider SET Salary = 65000 WHERE ProviderID = '123456';
UPDATE Provider SET Salary = 9500 WHERE ProviderID = '123457';
UPDATE Provider SET Salary = 142000 WHERE ProviderID = '123458';
UPDATE Provider SET Salary = 130000 WHERE ProviderID = '123459';
UPDATE Provider SET Salary = 160000 WHERE ProviderID = '123460';
SELECT*FROM PROVIDER;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Share

Link to this answer
Share Copy Link

Contributed on Dec 21 2021

Plain Puffin

0 Answers Avg Quality 2/10

sql statement checker corrector

Comment

0

CREATE TABLE Provider (ProviderID CHAR(6) not null, FirstName VARCHAR(24) not null,
                       LastName VARCHAR(64) not null, PRIMARY KEY (ProviderID) );
INSERT INTO Provider (ProviderID, LastName, FirstName) 
VALUES ('123456', 'Spock', 'Ben');
ALTER TABLE Provider ADD COLUMN HireDate date;
UPDATE Provider SET FirstName = 'Ben' WHERE ProviderID = '123456';
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123457', 'Schweitzer', 'Albert', '1990-05-09');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123458', 'Shepherd', 'Derek', '2005-03-27');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123459', 'Sloan', 'Mark', '2005-03-27');
INSERT INTO Provider (ProviderID, LastName, FirstName, HireDate)
VALUES ('123460', 'Thomas', 'Brett', '2020-01-15');
ALTER TABLE Provider ADD COLUMN Salary float;
UPDATE Provider SET Salary = 65000 WHERE ProviderID = '123456';
UPDATE Provider SET Salary = 9500 WHERE ProviderID = '123457';
UPDATE Provider SET Salary = 142000 WHERE ProviderID = '123458';
UPDATE Provider SET Salary = 130000 WHERE ProviderID = '123459';
UPDATE Provider SET Salary = 160000 WHERE ProviderID = '123460';
INSERT INTO Provider (ProviderID, FirstName, LastName, HireDate)
VALUES('123461','George', 'Brett', '2020-04-01');

CREATE TABLE Patient (PatientID, CHAR(6) not full, FirstName VARCHAR(24) not null, LastName VARCHAR(64) not full, 
                      DOB date, PrimaryProviderID CHAR(6), PRIMARY KEY (PatientID) );
INSERT INTO Patient VALUES ('000001', 'Brad', 'Parker', '1986-03-22', '123456');
INSERT INTO Patient VALUES ('000003', 'Diana', 'Prince', '2002-12-09', '123457');
INSERT INTO Patient VALUES ('000004', 'Bruce', 'Wayne', '1970-04-14', '123459');

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Share

Link to this answer
Share Copy Link

Contributed on Dec 22 2021

Plain Puffin

0 Answers Avg Quality 2/10

how to check if sql query is correct online

Contents

More Related Answers