查找所有员工入职时候的薪水情况

  题目:

    题目描述
 查找所有员工入职时候的薪水情况，给出emp_no以及salary， 并按照emp_no进行逆序
   CREATE TABLE `employees` (
   `emp_no` int(11) NOT NULL,
    `birth_date` date NOT NULL,
   `first_name` varchar(14) NOT NULL,
    `last_name` varchar(16) NOT NULL,
    `gender` char(1) NOT NULL,
   `hire_date` date NOT NULL, 
    PRIMARY KEY (`emp_no`));
   CREATE TABLE `salaries` (
   `emp_no` int(11) NOT NULL,
   `salary` int(11) NOT NULL,
   `from_date` date NOT NULL,
   `to_date` date NOT NULL,
   PRIMARY KEY (`emp_no`,`from_date`));

sql:

select e.emp_no , s.salary from employees e , salaries s where s.emp_no = e.emp_no and s.from_date = e.hire_date
ORDER BY e.emp_no desc