Write query to solve question

1 files changed, 22 insertions, 0 deletions

diff --git a/assignments/2/run.sql b/assignments/2/run.sql
index e69de29..25101a8 100644
--- a/assignments/2/run.sql
+++ b/assignments/2/run.sql
@@ -0,0 +1,22 @@
+-- \echo '--- Question 4 ---'
+
+DROP TABLE IF EXISTS Employee;
+DROP TABLE IF EXISTS ProjAssigned;
+
+CREATE TABLE Employee(
+  "emp-no" bigint primary key,
+  name varchar(255),
+  department varchar(255),
+  salary decimal
+);
+
+CREATE TABLE ProjAssigned(
+  "emp-no" bigint,
+  "proj-no" bigint,
+  "worked-hours" integer
+);
+
+SELECT e."emp-no", e.name, pa."proj-no", pa."worked-hours"
+FROM Employee e
+INNER JOIN ProjAssigned pa ON pa."emp-no" = e."emp-no"
+WHERE e.salary > 66000;