title: sql query for retrieving data from two tables
body: <p>There are two tables as below</p>
  
  <p>employee table: <code>empid, empname, deptid</code></p>
  
  <p>department table: <code>deptid, deptname</code></p>
  
  <p>then write query to "list all employees for dept name=computer"</p>