week1code.html

<!doctype html>

<!-- this is a comment for human! -->

<html lang="en">

<header>
  <!-- change the name to yours! -->
  <title>SQL for Data-Science </title>
  <!-- link to the master cascading stylesheet -->
  <link rel="stylesheet" href="css/master.css">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <meta name="name" content="SQL for Data-science">
</header>

<body>
  
  <!-- add the name for the website -->
  <h1>SQL for Data-science Coursera Assignment Answers</h1>

  <!-- add a section called "About Me" -->
  <h2>Week 1 Coding</h2>

  <!-- add a few paragraph lines to describe you -->
  <p><h5>1. Retrieve all the records from the Employees table.</h5></p> <!-- where do you live? -->
  <p>code:</p> <!-- Where studying/studied? -->
  <p>  select * from Employees;   </p>
  <p> What is Robert King's mailing address? Note: You will have to scroll to the right in order to see it. </p>
  <p>Answer : 590 Columbia Boulevard West, Lethbridge, AB, CANADA T1K 5N8 </p>
 

<p><h5>2. Retrieve the FirstName, LastName, Birthdate, Address, City, and State from the Employees table.)</h5></p>
<p>code:</p>
<p>select FirstName, LastName, Birthdate, Address, City, State
from Employees </p>
<p>	Which of the employees listed below has a birthdate of 3-3-1965?</p>
<p>Answer : Steve</p>



<p><h5> 3. Retrieve all the columns from the Tracks table, but only return 20 rows. </h5></p>
<p>code:</p>
<p> select * from Tracks limit 20; </p>
<p>What is the runtime in milliseconds for the 5th track, entitled "Princess of the Dawn"? Note: You will need to scroll to the right to see it, and you may want to copy and paste the number to ensure it is entered correctly.</p>
<p>Answer : 375418</p>



</body>

<footer>
  <hr>
  <!-- change the name to yours! -->
  <code>Copyright (C) 2020 Mayank Pathak</code>
</footer>

</html>