[x] Design a simple application to convert text to sql, it can be command line
[x] Make simple queries.
[x] Complex Queries
Test Cases:
One where condition.
Ex. What is "name" salary?
SELECT Base Salary
FROM Compensation
WHERE Name = 'Mark Zuckerberg'
Multiple where conditions
EX. Who makes less than $100k base in software engineering dept?
SELECT Name
FROM Compensation
WHERE Department = 'Software Engineering' AND Base Salary < 10000
With an aggregation
EX. “total stock award given out to ppl in data science hired after 2000?"
SELECT SUM(Stock Awards)
FROM Compensation
WHERE Department = 'Data Science' AND Hiring Date > 2000-01-01
With JOIN, GROUB BY, HAVING, ORDER BY
EX. “What is Mark Zuckerberg's salary?"
SELECT Base Salary
FROM Compensation c
JOIN Employees e ON c.EmployeeId = e.EmployeeId
WHERE e.FirstName = 'Mark' AND e.LastName = 'Zuckerberg'
TASKS
Test Cases:
SELECT Base Salary FROM Compensation WHERE Name = 'Mark Zuckerberg'
Multiple where conditions EX. Who makes less than $100k base in software engineering dept? SELECT Name FROM Compensation WHERE Department = 'Software Engineering' AND Base Salary < 10000
With an aggregation EX. “total stock award given out to ppl in data science hired after 2000?" SELECT SUM(Stock Awards) FROM Compensation WHERE Department = 'Data Science' AND Hiring Date > 2000-01-01
With JOIN, GROUB BY, HAVING, ORDER BY EX. “What is Mark Zuckerberg's salary?" SELECT Base Salary FROM Compensation c JOIN Employees e ON c.EmployeeId = e.EmployeeId WHERE e.FirstName = 'Mark' AND e.LastName = 'Zuckerberg'