WillyVervest
/
How_to_retrieve_data_from_a_single_table
forked from RafVergauwen/How_to_retrieve_data_from_a_single_table
Watch 1
Star 0
Fork 0
Code Issues 0 Pull Requests 0 Releases 0 Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
13 Commits
1 Branch
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
How_to_retrieve_data_from_a.../exer_5C42.sql

exer_5C42.sql 136B
Raw Permalink Blame History

123456 
  1. USE AP;

  2. 

  3. SELECT MIN(vendor_name) AS first_vendor,

  4. MAX(vendor_name) AS last_vendor,

  5. COUNT(vendor_name) AS number_of_vendors

  6. FROM vendors;