Sql

Question

If u have a table with column names ‘country’, ‘hiredate’ ‘empid’ what is the syntax to get the hire country; hiredate; and the number of employees hired after 20030101 from the table

Answer 1

SELECT country, hiredate FROM hr WHERE hiredate>'2003-01-01';
SELECT COUNT(*) 'Total Employees' FROM hr WHERE hiredate>'2003-01-01';

Tested on http://sqlfiddle.com/#!9/2a7fad/8

Answer 2

thanks guys