Order by name ascending

1 files changed, 9 insertions, 1 deletions

diff --git a/assignments/2/run.sql b/assignments/2/run.sql
index 25101a8..09551d6 100644
--- a/assignments/2/run.sql
+++ b/assignments/2/run.sql
@@ -16,7 +16,15 @@ CREATE TABLE ProjAssigned(
   "worked-hours" integer
 );
 
+INSERT INTO Employee VALUES (1, 'A', 'Ruby', 200000);
+INSERT INTO Employee VALUES (2, 'B', 'Golang', 300000);
+INSERT INTO Employee VALUES (3, 'C', 'C', 400000);
+
+INSERT INTO ProjAssigned VALUES (1, 1, 40);
+INSERT INTO ProjAssigned VALUES (2, 2, 80);
+
 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;
+WHERE e.salary > 66000
+ORDER BY e.name ASC;