Database Join Table

 Order By Aes And Desc

SELECT store_name, Sales, Date
FROM Store_Information
ORDER BY Sales DESC

select a.Emp_Name From Emp_Details as a,Emp_Salary as b,Emp_Age as c where a.Emp_Id =b.Emp_Id And b.Emp_Id = c.Emp_Id and b.Emp_Salary>=40000 And c.Emp_Age>=21




select a.Emp_Name,a.Emp_Id ,b.Emp_Salary,c.Emp_Age From Emp_Details as a,Emp_Salary as b,Emp_Age as c where a.Emp_Id =b.Emp_Id And b.Emp_Id = c.Emp_Id And b.Emp_Salary>=30000 And c.Emp_Age>=21


select a.Emp_Name,a.Emp_Id ,a.Emp_City,b.Emp_Salary,c.Emp_Age From Emp_Details AS a INNER JOIN Emp_Salary AS b ON a.Emp_Id=b.Emp_Id INNER JOIN Emp_Age AS c ON b.Emp_Id =c.Emp_Id where  b.Emp_Salary >=30000 AND c.Emp_Age>=21