New Paste

Content

CREATE TABLE employe(
    employe_id int PRIMARY KEY,
    name VARCHAR(20),
    salary varchar(20),
    department varchar(20),
    hire_date DATE
    );
    
    INSERT INTO employe(employe_id, name, salary, department, hire_date)
VALUES 
    (1, 'Alice Smith', 9000, 'engineering', '2023-02-15'),
    (2, 'Bob Johan', 8500, 'marketing', '2022-11-05'),
    (3, 'Carol Lee', 9500, 'engineering', '2021-07-20'),
    (4, 'Dave Brown', 8000, 'sales', '2023-03-10'),
    (5, 'Ece Davis', 10000, 'HR', '2022-08-30');
    
    1))SELECT *
FROM employe
WHERE department = 'engineering'
  AND salary > 8000;
  
  2))SELECT *
FROM employees e
WHERE salary > (
    SELECT AVG(salary)
    FROM employees
    WHERE department = e.department
);

3))SELECT name
FROM employe
WHERE department = 'HR';

4))SELECT department, COUNT(*) AS employe_count
FROM employe
GROUP BY department;

5)SELECT *
FROM employe
WHERE YEAR(hire_date) = 2022
  AND salary > 8000;

6))SELECT *
FROM employe
WHERE department <> 'engineering'
  AND salary < 9000;

7))SELECT 
    MAX(salary) AS highest_salary,
    MIN(salary) AS lowest_salary
FROM employe;

9))SELECT COUNT(*) AS count_employe
FROM employe
WHERE name LIKE 'C%';
10))
SELECT *
FROM employe
WHERE name LIKE '_L%';

Optional Paste Settings

Title

Select folder or

Syntax Highlighting

Paste Expiration

Paste Status

Password

Description

Our statistics

Create and share texts quickly and easily 🚀

336,899+

Total pastes

172,885,158+

Total views

125+

Registered users

Our features

Everything you need 😉

Pastes creation

Create multiple posts quickly and easily with our powerful editor.

Folders

Store your pastes in different folders with custom names.

Paste protection

Protect your pastes with password, encryption and captcha.

Multiple syntax languages

We have 150+ syntax languages for your codes.

URL monetization

Earn money by enabling url shorteners in your pastes.

Global settings

Configure each aspect of your pastes globally.

Recent Pastes

Why You Should Concentrate On Enhancing Gutter Replacement Cost UK
HTML | 68 | 25 seconds ago
The Ultimate Guide to Grasping Distributed Ledger Systems
HTML | 417 | 54 seconds ago
15 Best Pinterest Boards To Pin On All Time About How Much To Repair A
HTML | 877 | 3 minutes ago
7 Easy Secrets To Totally Intoxicating Your Untreated ADHD In Adults T
HTML | 338 | 4 minutes ago
How To Edit DOC Files Without Microsoft Word
HTML | 778 | 5 minutes ago
10 Quick Tips On Downpipe Repairs
HTML | 597 | 5 minutes ago
Why Everyone Is Talking About Robot Vacuum Cleaner Black Friday Today
HTML | 93 | 5 minutes ago