Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

A A A
Login    Share code      Blog   FAQ
Copy Format Clear
CREATE TABLE Sales ( office_id INT, actual_sales DECIMAL(10, 2), planned_sales DECIMAL(10, 2) ); SELECT office_id FROM Sales WHERE actual_sales > planned_sales; CREATE TABLE EmployeeSales ( employee_id INT, employee_name VARCHAR(50), sales_amount DECIMAL(10, 2), sales_quota DECIMAL(10, 2) ); SELECT employee_name, sales_amount, sales_quota FROM EmployeeSales WHERE employee_id = 105;

Stuck with a problem? Got Error? Ask AI support!

Copy Clear