SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
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 ChatGPT!
Copy Clear