Welcome to the SQL section of my portfolio. Here, you can explore various SQL queries that interact with the underlying database for this site. Each query is designed to showcase different aspects of SQL, including data retrieval, updates, and analysis.
Select a query below to view the details and see how it functions:
Min & Max Salaries Number of Employees Marketing Employees Number of Jobs Department Name Unique First Names FirstThreeCharactersSelect a table below to view its contents
Employees Countries Departments Job History Jobs Locations RegionsQuery to return each table
SELECT * FROM departments
| DEPARTMENT_ID | DEPARTMENT_NAME | MANAGER_ID | LOCATION_ID |
|---|---|---|---|
| 10 | Administration | 200 | 1700 |
| 20 | Marketing | 201 | 1800 |
| 30 | Purchasing | 114 | 1700 |
| 40 | Human Resources | 203 | 2400 |
| 50 | Shipping | 121 | 1500 |
| 60 | IT | 103 | 1400 |
| 70 | Public Relations | 204 | 2700 |
| 80 | Sales | 145 | 2500 |
| 90 | Executive | 100 | 1700 |
| 100 | Finance | 108 | 1700 |
| 110 | Accounting | 205 | 1700 |
| 120 | Treasury | 0 | 1700 |
| 130 | Corporate Tax | 0 | 1700 |
| 140 | Control And Credit | 0 | 1700 |
| 150 | Shareholder Services | 0 | 1700 |
| 160 | Benefits | 0 | 1700 |
| 170 | Manufacturing | 0 | 1700 |
| 180 | Construction | 0 | 1700 |
| 190 | Contracting | 0 | 1700 |
| 200 | Operations | 0 | 1700 |
| 210 | IT Support | 0 | 1700 |
| 220 | NOC | 0 | 1700 |
| 230 | IT Helpdesk | 0 | 1700 |
| 240 | Government Sales | 0 | 1700 |
| 250 | Retail Sales | 0 | 1700 |
| 260 | Recruiting | 0 | 1700 |
| 270 | Payroll | 0 | 1700 |