title: How to structure these SQL queries so they are perfect SQL?
body: <p>I have to structure these queries so they are perfect SQL. The queries need to be for a SQL Server database, I have a database <code>StoresDB</code>, a table <code>items_table</code>. </p>
  
  <p>I need to retrieve the </p>
  
  <ol>
  <li><p>total number of items within this table</p></li>
  <li><p>The number of item where the price is higher or equal than £10 - the column name is amount</p></li>
  <li><p>The list of items in the computer category - column name ='comp_id' sorted by decreased amount. </p></li>
  </ol>
  
  <p>For the above requests I have attempted the below:</p>
  
  <ol>
  <li><p><code>SELECT COUNT(*) FROM items_table</code></p></li>
  <li><p><code>Select * from items_table where amount &gt;= 10</code></p></li>
  <li><p><code>Select * from items_table where comp_id = ’electronics’ desc</code></p></li>
  </ol>
  
  <p>I am very new to SQL and not sure if I have attempted this correctly.</p>