Total Records
Distributions
Total Revenue
Latest Upload
Works
Countries
Performances
Composers/Publishers
CREATE TABLE users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
username TEXT NOT NULL,
email TEXT UNIQUE NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE products (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
price DECIMAL(10,2),
category TEXT,
active BOOLEAN DEFAULT 1
);
CREATE TABLE orders (
id INTEGER PRIMARY KEY AUTOINCREMENT,
user_id INTEGER,
total_amount DECIMAL(10,2),
order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(id)
);
INSERT INTO users (username, email) VALUES
('john_doe', '[email protected]'),
('jane_smith', '[email protected]');
INSERT INTO products (name, price, category) VALUES
('Laptop', 999.99, 'Electronics'),
('Headphones', 89.99, 'Electronics');
-- Basic Select SELECT * FROM users; -- Joins SELECT users.username, orders.total_amount FROM users JOIN orders ON users.id = orders.user_id; -- Aggregations SELECT category, COUNT(*) as item_count, AVG(price) as avg_price FROM products GROUP BY category;
UPDATE products SET price = 79.99 WHERE name = 'Headphones'; UPDATE users SET email = '[email protected]' WHERE username = 'john_doe';
DELETE FROM products
WHERE id = 1;
DELETE FROM orders
WHERE order_date < DATE('now', '-1 year');
-- Complex Join with Aggregation
SELECT
users.username,
COUNT(orders.id) as order_count,
SUM(orders.total_amount) as total_spent
FROM users
LEFT JOIN orders ON users.id = orders.user_id
GROUP BY users.id, users.username
HAVING total_spent > 100;
-- Subquery Example
SELECT name, price
FROM products
WHERE price > (
SELECT AVG(price)
FROM products
);
-- List all tables SELECT name FROM sqlite_master WHERE type='table'; -- Get table schema SELECT sql FROM sqlite_master WHERE name='users'; -- Vacuum database VACUUM;
or
| Name | Size | Type | Upload Date | Status | Actions |
|---|---|---|---|---|---|
|
Loading...
Loading files...
|
|||||
| Column Name | Type | Description |
|---|