summaryrefslogtreecommitdiff
path: root/graphs/sql/job_hunt
diff options
context:
space:
mode:
Diffstat (limited to 'graphs/sql/job_hunt')
-rw-r--r--graphs/sql/job_hunt/req01.sql1
-rw-r--r--graphs/sql/job_hunt/req02.sql1
-rw-r--r--graphs/sql/job_hunt/req03.sql1
3 files changed, 3 insertions, 0 deletions
diff --git a/graphs/sql/job_hunt/req01.sql b/graphs/sql/job_hunt/req01.sql
new file mode 100644
index 0000000..c1d362d
--- /dev/null
+++ b/graphs/sql/job_hunt/req01.sql
@@ -0,0 +1 @@
+SELECT * FROM public.jobs
diff --git a/graphs/sql/job_hunt/req02.sql b/graphs/sql/job_hunt/req02.sql
new file mode 100644
index 0000000..d5af78e
--- /dev/null
+++ b/graphs/sql/job_hunt/req02.sql
@@ -0,0 +1 @@
+SELECT job_id,contract_type,start_date FROM public.job_offers
diff --git a/graphs/sql/job_hunt/req03.sql b/graphs/sql/job_hunt/req03.sql
new file mode 100644
index 0000000..4e8f291
--- /dev/null
+++ b/graphs/sql/job_hunt/req03.sql
@@ -0,0 +1 @@
+SELECT DISTINCT contract_type FROM public.job_offers