Validated SQL Query Examples

SELECT * FORM dish WHERE NAME = 'Prawn Salad';

SELECT * FROM artist WHERE first_name = 'Vincent' and (last_name = 'Monet' or last_name = 'Da Vinci';

SELECT name FROM dish WHERE name = 'Prawn Salad' ORDER BY name GROUP BY name HAVING count(*) = 1

SELECT * FROM exhibit JOIN exhibit ON (id = previous_id);

ERROR: relation "largeclient" does not exist. SELECT * FROM LargeClient WHERE cust_name = 'Mijona';

CREATE TABLE student ( student_id INT PRIMARY KEY, name VARCHAR(20), major VARCHAR(20), ); INSERT I...

UPDATE dbo.OBJECT SET LANGNAME = 'FooBar' WHERE dbo.OBJECT."OBJEC_ID" IN (69, 42, 1337)

SELECT m.dname, COUNT(*) AS 'Total Students', AVG(s.age) AS 'Average Age', AVG(s.gpa) AS 'Average G...

;WITH Base AS ( SELECT * FROM F_Inputs(1,1,100021) ), U AS ( SELECT ISNULL(q.CoverPK,r.Cov...

create table currencyIndex ( id int auto_increment, isoCode VARCHAR2(3) not null, isoCod...

const [rows, fields] = await connection.execute( "INSERT INTO Testing (Email) VALUES (${JSON.strin...

CREATE TABLE ACCOUNT ( ACCNO NUMBER(5) NOT NULL, NAME VARCHAR(20) NOT NULL, BA L NUMBER(8,2) N...