Movatterモバイル変換
[0]
ホーム
URL:
画像なし
夜間モード
SQL.js Interpreter
Execute
Save DB
Load DB
Examples
SQL Editor
-- Basic SQL Demo-- Create a simple employees tableDROP TABLE IF EXISTS employees;CREATE TABLE employees ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, department TEXT, salary NUMERIC, hire_date DATE);-- Insert sample dataINSERT INTO employees (name, department, salary, hire_date) VALUES ('Alice Smith', 'Engineering', 85000, '2020-01-15'), ('Bob Johnson', 'Marketing', 72000, '2019-03-20'), ('Carol Williams', 'Engineering', 92000, '2018-11-07'), ('Dave Brown', 'Finance', 115000, '2017-05-12'), ('Eve Davis', 'Engineering', 110000, '2021-08-30');-- Query the dataSELECT department, COUNT(*) as employee_count, ROUND(AVG(salary), 2) as avg_salaryFROM employeesGROUP BY departmentORDER BY avg_salary DESC;
Ready
Result 1
+
Results will be displayed here
No query executed yet
Result
×
Execute a query to see results
Executing query...
Query failed
[8]
ページ先頭
©2009-2025
Movatter.jp