WEBVTT
Kind: captions
Language: en

00:00:05.660 --> 00:00:09.709 align:start position:0%
 
in<00:00:06.660><c> the</c><00:00:07.589><c> last</c><00:00:07.830><c> lesson</c><00:00:08.160><c> we</c><00:00:08.519><c> designed</c><00:00:09.030><c> and</c><00:00:09.450><c> built</c>

00:00:09.709 --> 00:00:09.719 align:start position:0%
in the last lesson we designed and built
 

00:00:09.719 --> 00:00:12.169 align:start position:0%
in the last lesson we designed and built
a<00:00:09.900><c> query</c><00:00:10.320><c> using</c><00:00:10.740><c> the</c><00:00:10.980><c> query</c><00:00:11.309><c> design</c><00:00:11.670><c> command</c>

00:00:12.169 --> 00:00:12.179 align:start position:0%
a query using the query design command
 

00:00:12.179 --> 00:00:14.870 align:start position:0%
a query using the query design command
now<00:00:12.990><c> we'll</c><00:00:13.259><c> build</c><00:00:13.559><c> another</c><00:00:13.920><c> query</c><00:00:14.370><c> but</c><00:00:14.670><c> this</c>

00:00:14.870 --> 00:00:14.880 align:start position:0%
now we'll build another query but this
 

00:00:14.880 --> 00:00:17.150 align:start position:0%
now we'll build another query but this
time<00:00:15.179><c> we'll</c><00:00:15.450><c> add</c><00:00:15.480><c> an</c><00:00:15.780><c> extra</c><00:00:16.170><c> function</c><00:00:16.470><c> that</c>

00:00:17.150 --> 00:00:17.160 align:start position:0%
time we'll add an extra function that
 

00:00:17.160 --> 00:00:20.240 align:start position:0%
time we'll add an extra function that
helps<00:00:17.400><c> summarize</c><00:00:18.060><c> our</c><00:00:18.330><c> results</c><00:00:19.010><c> then</c><00:00:20.010><c> we'll</c>

00:00:20.240 --> 00:00:20.250 align:start position:0%
helps summarize our results then we'll
 

00:00:20.250 --> 00:00:22.250 align:start position:0%
helps summarize our results then we'll
sort<00:00:20.520><c> and</c><00:00:20.640><c> filter</c><00:00:20.670><c> our</c><00:00:21.060><c> query</c><00:00:21.390><c> results</c><00:00:22.020><c> to</c>

00:00:22.250 --> 00:00:22.260 align:start position:0%
sort and filter our query results to
 

00:00:22.260 --> 00:00:25.040 align:start position:0%
sort and filter our query results to
define<00:00:22.590><c> them</c><00:00:22.800><c> even</c><00:00:23.160><c> more</c><00:00:23.340><c> okay</c><00:00:23.670><c> now</c><00:00:24.570><c> this</c><00:00:24.779><c> time</c>

00:00:25.040 --> 00:00:25.050 align:start position:0%
define them even more okay now this time
 

00:00:25.050 --> 00:00:26.929 align:start position:0%
define them even more okay now this time
let's<00:00:25.350><c> build</c><00:00:25.740><c> a</c><00:00:25.830><c> query</c><00:00:26.070><c> to</c><00:00:26.250><c> find</c><00:00:26.400><c> out</c><00:00:26.730><c> what</c>

00:00:26.929 --> 00:00:26.939 align:start position:0%
let's build a query to find out what
 

00:00:26.939 --> 00:00:30.580 align:start position:0%
let's build a query to find out what
category<00:00:27.539><c> of</c><00:00:27.599><c> books</c><00:00:27.869><c> we</c><00:00:28.439><c> sell</c><00:00:28.710><c> most</c><00:00:29.099><c> often</c>

00:00:30.580 --> 00:00:30.590 align:start position:0%
category of books we sell most often
 

00:00:30.590 --> 00:00:33.080 align:start position:0%
category of books we sell most often
start<00:00:31.590><c> by</c><00:00:31.740><c> thinking</c><00:00:31.800><c> about</c><00:00:32.160><c> what</c><00:00:32.340><c> we</c><00:00:32.700><c> want</c><00:00:32.940><c> our</c>

00:00:33.080 --> 00:00:33.090 align:start position:0%
start by thinking about what we want our
 

00:00:33.090 --> 00:00:35.540 align:start position:0%
start by thinking about what we want our
results<00:00:33.690><c> to</c><00:00:33.780><c> look</c><00:00:33.809><c> like</c><00:00:34.170><c> this</c><00:00:34.920><c> will</c><00:00:35.160><c> help</c><00:00:35.309><c> us</c>

00:00:35.540 --> 00:00:35.550 align:start position:0%
results to look like this will help us
 

00:00:35.550 --> 00:00:38.660 align:start position:0%
results to look like this will help us
know<00:00:35.790><c> what</c><00:00:36.300><c> we</c><00:00:36.450><c> need</c><00:00:36.719><c> we</c><00:00:37.649><c> want</c><00:00:37.950><c> to</c><00:00:38.129><c> see</c><00:00:38.370><c> the</c>

00:00:38.660 --> 00:00:38.670 align:start position:0%
know what we need we want to see the
 

00:00:38.670 --> 00:00:41.119 align:start position:0%
know what we need we want to see the
title<00:00:39.270><c> the</c><00:00:39.570><c> author's</c><00:00:39.899><c> first</c><00:00:39.930><c> name</c><00:00:40.379><c> and</c><00:00:40.950><c> last</c>

00:00:41.119 --> 00:00:41.129 align:start position:0%
title the author's first name and last
 

00:00:41.129 --> 00:00:44.060 align:start position:0%
title the author's first name and last
name<00:00:41.370><c> the</c><00:00:41.910><c> category</c><00:00:42.510><c> and</c><00:00:43.230><c> the</c><00:00:43.500><c> price</c><00:00:43.800><c> of</c><00:00:43.980><c> our</c>

00:00:44.060 --> 00:00:44.070 align:start position:0%
name the category and the price of our
 

00:00:44.070 --> 00:00:47.060 align:start position:0%
name the category and the price of our
best-selling<00:00:44.610><c> books</c><00:00:45.000><c> and</c><00:00:45.440><c> maybe</c><00:00:46.440><c> we</c><00:00:47.039><c> even</c>

00:00:47.060 --> 00:00:47.070 align:start position:0%
best-selling books and maybe we even
 

00:00:47.070 --> 00:00:49.069 align:start position:0%
best-selling books and maybe we even
want<00:00:47.579><c> to</c><00:00:47.640><c> see</c><00:00:47.850><c> the</c><00:00:47.969><c> number</c><00:00:48.360><c> of</c><00:00:48.390><c> times</c><00:00:48.780><c> each</c>

00:00:49.069 --> 00:00:49.079 align:start position:0%
want to see the number of times each
 

00:00:49.079 --> 00:00:53.540 align:start position:0%
want to see the number of times each
book<00:00:49.559><c> was</c><00:00:49.770><c> ordered</c><00:00:51.289><c> if</c><00:00:52.289><c> we</c><00:00:52.920><c> decide</c><00:00:53.280><c> we</c><00:00:53.309><c> don't</c>

00:00:53.540 --> 00:00:53.550 align:start position:0%
book was ordered if we decide we don't
 

00:00:53.550 --> 00:00:55.760 align:start position:0%
book was ordered if we decide we don't
want<00:00:54.059><c> this</c><00:00:54.180><c> information</c><00:00:54.390><c> once</c><00:00:55.199><c> we've</c><00:00:55.410><c> run</c><00:00:55.649><c> the</c>

00:00:55.760 --> 00:00:55.770 align:start position:0%
want this information once we've run the
 

00:00:55.770 --> 00:00:58.250 align:start position:0%
want this information once we've run the
query<00:00:56.129><c> we</c><00:00:56.640><c> can</c><00:00:56.760><c> always</c><00:00:57.329><c> go</c><00:00:57.510><c> back</c><00:00:57.539><c> and</c><00:00:57.750><c> delete</c>

00:00:58.250 --> 00:00:58.260 align:start position:0%
query we can always go back and delete
 

00:00:58.260 --> 00:01:00.439 align:start position:0%
query we can always go back and delete
it<00:00:58.440><c> but</c><00:00:59.309><c> it's</c><00:00:59.460><c> a</c><00:00:59.579><c> good</c><00:00:59.789><c> idea</c><00:00:59.940><c> to</c><00:01:00.180><c> include</c>

00:01:00.439 --> 00:01:00.449 align:start position:0%
it but it's a good idea to include
 

00:01:00.449 --> 00:01:02.810 align:start position:0%
it but it's a good idea to include
everything<00:01:01.140><c> you</c><00:01:01.590><c> think</c><00:01:01.770><c> you</c><00:01:01.890><c> might</c><00:01:02.370><c> want</c>

00:01:02.810 --> 00:01:02.820 align:start position:0%
everything you think you might want
 

00:01:02.820 --> 00:01:05.359 align:start position:0%
everything you think you might want
while<00:01:03.570><c> you're</c><00:01:03.809><c> planning</c><00:01:04.019><c> the</c><00:01:04.290><c> query</c><00:01:04.650><c> so</c><00:01:05.189><c> we'll</c>

00:01:05.359 --> 00:01:05.369 align:start position:0%
while you're planning the query so we'll
 

00:01:05.369 --> 00:01:08.990 align:start position:0%
while you're planning the query so we'll
include<00:01:05.640><c> it</c><00:01:05.820><c> in</c><00:01:05.970><c> our</c><00:01:06.060><c> plan</c><00:01:07.280><c> next</c><00:01:08.280><c> identify</c><00:01:08.939><c> the</c>

00:01:08.990 --> 00:01:09.000 align:start position:0%
include it in our plan next identify the
 

00:01:09.000 --> 00:01:11.539 align:start position:0%
include it in our plan next identify the
tables<00:01:09.540><c> we'll</c><00:01:09.689><c> need</c><00:01:09.869><c> this</c><00:01:10.560><c> time</c><00:01:10.950><c> we'll</c><00:01:11.520><c> just</c>

00:01:11.539 --> 00:01:11.549 align:start position:0%
tables we'll need this time we'll just
 

00:01:11.549 --> 00:01:14.050 align:start position:0%
tables we'll need this time we'll just
need<00:01:11.880><c> the</c><00:01:12.030><c> orders</c><00:01:12.390><c> table</c><00:01:12.600><c> in</c><00:01:12.960><c> the</c><00:01:13.110><c> books</c><00:01:13.320><c> table</c>

00:01:14.050 --> 00:01:14.060 align:start position:0%
need the orders table in the books table
 

00:01:14.060 --> 00:01:16.640 align:start position:0%
need the orders table in the books table
finally<00:01:15.060><c> think</c><00:01:15.540><c> about</c><00:01:15.630><c> the</c><00:01:15.900><c> conditions</c><00:01:16.500><c> we</c>

00:01:16.640 --> 00:01:16.650 align:start position:0%
finally think about the conditions we
 

00:01:16.650 --> 00:01:19.160 align:start position:0%
finally think about the conditions we
need<00:01:16.799><c> our</c><00:01:17.009><c> data</c><00:01:17.310><c> to</c><00:01:17.549><c> meet</c><00:01:17.790><c> we</c><00:01:18.689><c> will</c><00:01:18.720><c> want</c><00:01:19.080><c> to</c>

00:01:19.160 --> 00:01:19.170 align:start position:0%
need our data to meet we will want to
 

00:01:19.170 --> 00:01:21.469 align:start position:0%
need our data to meet we will want to
see<00:01:19.439><c> only</c><00:01:19.890><c> the</c><00:01:20.040><c> books</c><00:01:20.340><c> that</c><00:01:20.729><c> show</c><00:01:20.970><c> up</c><00:01:21.180><c> in</c><00:01:21.390><c> the</c>

00:01:21.469 --> 00:01:21.479 align:start position:0%
see only the books that show up in the
 

00:01:21.479 --> 00:01:23.960 align:start position:0%
see only the books that show up in the
orders<00:01:21.840><c> table</c><00:01:22.080><c> and</c><00:01:22.979><c> we</c><00:01:23.130><c> want</c><00:01:23.310><c> to</c><00:01:23.520><c> know</c><00:01:23.700><c> which</c>

00:01:23.960 --> 00:01:23.970 align:start position:0%
orders table and we want to know which
 

00:01:23.970 --> 00:01:26.660 align:start position:0%
orders table and we want to know which
books<00:01:24.360><c> ID</c><00:01:24.659><c> number</c><00:01:25.290><c> shows</c><00:01:25.920><c> up</c><00:01:26.189><c> most</c><00:01:26.430><c> often</c>

00:01:26.660 --> 00:01:26.670 align:start position:0%
books ID number shows up most often
 

00:01:26.670 --> 00:01:30.319 align:start position:0%
books ID number shows up most often
there<00:01:27.240><c> so</c><00:01:28.020><c> we</c><00:01:28.259><c> need</c><00:01:28.530><c> to</c><00:01:28.770><c> count</c><00:01:29.130><c> how</c><00:01:29.700><c> often</c><00:01:30.210><c> each</c>

00:01:30.319 --> 00:01:30.329 align:start position:0%
there so we need to count how often each
 

00:01:30.329 --> 00:01:33.140 align:start position:0%
there so we need to count how often each
book<00:01:30.659><c> ID</c><00:01:30.869><c> appears</c><00:01:31.439><c> in</c><00:01:31.680><c> the</c><00:01:31.829><c> orders</c><00:01:32.130><c> table</c><00:01:32.369><c> all</c>

00:01:33.140 --> 00:01:33.150 align:start position:0%
book ID appears in the orders table all
 

00:01:33.150 --> 00:01:35.840 align:start position:0%
book ID appears in the orders table all
right<00:01:33.810><c> we</c><00:01:34.290><c> have</c><00:01:34.439><c> our</c><00:01:34.619><c> plan</c><00:01:34.890><c> so</c><00:01:35.520><c> let's</c><00:01:35.729><c> get</c>

00:01:35.840 --> 00:01:35.850 align:start position:0%
right we have our plan so let's get
 

00:01:35.850 --> 00:01:39.859 align:start position:0%
right we have our plan so let's get
started<00:01:36.560><c> from</c><00:01:37.560><c> the</c><00:01:37.740><c> create</c><00:01:38.130><c> tab</c><00:01:38.659><c> select</c><00:01:39.659><c> the</c>

00:01:39.859 --> 00:01:39.869 align:start position:0%
started from the create tab select the
 

00:01:39.869 --> 00:01:44.300 align:start position:0%
started from the create tab select the
query<00:01:40.229><c> design</c><00:01:40.710><c> command</c><00:01:42.619><c> pick</c><00:01:43.619><c> which</c><00:01:43.829><c> tables</c>

00:01:44.300 --> 00:01:44.310 align:start position:0%
query design command pick which tables
 

00:01:44.310 --> 00:01:46.370 align:start position:0%
query design command pick which tables
or<00:01:44.430><c> queries</c><00:01:44.640><c> you</c><00:01:44.880><c> want</c><00:01:45.180><c> to</c><00:01:45.360><c> use</c><00:01:45.630><c> as</c><00:01:45.840><c> a</c><00:01:45.869><c> basis</c>

00:01:46.370 --> 00:01:46.380 align:start position:0%
or queries you want to use as a basis
 

00:01:46.380 --> 00:01:48.440 align:start position:0%
or queries you want to use as a basis
for<00:01:46.409><c> the</c><00:01:46.590><c> new</c><00:01:46.710><c> query</c><00:01:47.130><c> we</c><00:01:47.939><c> need</c><00:01:48.119><c> the</c><00:01:48.270><c> books</c>

00:01:48.440 --> 00:01:48.450 align:start position:0%
for the new query we need the books
 

00:01:48.450 --> 00:01:51.139 align:start position:0%
for the new query we need the books
table<00:01:48.750><c> and</c><00:01:49.140><c> the</c><00:01:49.229><c> orders</c><00:01:49.649><c> table</c><00:01:50.040><c> so</c><00:01:50.700><c> pick</c><00:01:50.939><c> those</c>

00:01:51.139 --> 00:01:51.149 align:start position:0%
table and the orders table so pick those
 

00:01:51.149 --> 00:01:55.100 align:start position:0%
table and the orders table so pick those
from<00:01:51.450><c> the</c><00:01:51.570><c> list</c><00:01:52.850><c> from</c><00:01:53.850><c> the</c><00:01:54.000><c> books</c><00:01:54.240><c> table</c><00:01:54.540><c> we</c>

00:01:55.100 --> 00:01:55.110 align:start position:0%
from the list from the books table we
 

00:01:55.110 --> 00:02:03.020 align:start position:0%
from the list from the books table we
want<00:01:55.350><c> everything</c><00:01:55.979><c> except</c><00:01:56.430><c> the</c><00:01:56.549><c> book</c><00:01:56.729><c> ID</c>

00:02:03.020 --> 00:02:03.030 align:start position:0%
 
 

00:02:03.030 --> 00:02:06.030 align:start position:0%
 
now<00:02:04.030><c> we</c><00:02:04.090><c> need</c><00:02:04.390><c> the</c><00:02:04.570><c> book</c><00:02:04.810><c> ID</c><00:02:05.079><c> from</c><00:02:05.590><c> the</c><00:02:05.649><c> orders</c>

00:02:06.030 --> 00:02:06.040 align:start position:0%
now we need the book ID from the orders
 

00:02:06.040 --> 00:02:08.699 align:start position:0%
now we need the book ID from the orders
table<00:02:06.280><c> so</c><00:02:06.790><c> we'll</c><00:02:06.909><c> drag</c><00:02:07.210><c> that</c><00:02:07.390><c> down</c><00:02:07.450><c> to</c><00:02:07.960><c> now</c>

00:02:08.699 --> 00:02:08.709 align:start position:0%
table so we'll drag that down to now
 

00:02:08.709 --> 00:02:10.529 align:start position:0%
table so we'll drag that down to now
this<00:02:08.860><c> makes</c><00:02:09.130><c> sure</c><00:02:09.280><c> we</c><00:02:09.580><c> have</c><00:02:09.759><c> a</c><00:02:09.789><c> list</c><00:02:10.179><c> of</c><00:02:10.300><c> all</c>

00:02:10.529 --> 00:02:10.539 align:start position:0%
this makes sure we have a list of all
 

00:02:10.539 --> 00:02:14.640 align:start position:0%
this makes sure we have a list of all
the<00:02:10.720><c> books</c><00:02:10.959><c> we</c><00:02:11.050><c> ordered</c><00:02:13.290><c> here</c><00:02:14.290><c> is</c><00:02:14.440><c> where</c><00:02:14.620><c> our</c>

00:02:14.640 --> 00:02:14.650 align:start position:0%
the books we ordered here is where our
 

00:02:14.650 --> 00:02:15.990 align:start position:0%
the books we ordered here is where our
count<00:02:15.190><c> comes</c><00:02:15.489><c> in</c>

00:02:15.990 --> 00:02:16.000 align:start position:0%
count comes in
 

00:02:16.000 --> 00:02:19.800 align:start position:0%
count comes in
if<00:02:16.420><c> we</c><00:02:16.630><c> click</c><00:02:16.900><c> run</c><00:02:17.349><c> right</c><00:02:17.709><c> now</c><00:02:18.300><c> we</c><00:02:19.300><c> see</c><00:02:19.569><c> one</c>

00:02:19.800 --> 00:02:19.810 align:start position:0%
if we click run right now we see one
 

00:02:19.810 --> 00:02:24.650 align:start position:0%
if we click run right now we see one
record<00:02:20.290><c> for</c><00:02:20.319><c> each</c><00:02:20.830><c> time</c><00:02:21.489><c> a</c><00:02:22.590><c> book</c><00:02:23.590><c> was</c><00:02:23.950><c> ordered</c>

00:02:24.650 --> 00:02:24.660 align:start position:0%
record for each time a book was ordered
 

00:02:24.660 --> 00:02:27.479 align:start position:0%
record for each time a book was ordered
well<00:02:25.660><c> access</c><00:02:26.260><c> can</c><00:02:26.470><c> group</c><00:02:26.650><c> the</c><00:02:26.769><c> records</c><00:02:27.250><c> with</c>

00:02:27.479 --> 00:02:27.489 align:start position:0%
well access can group the records with
 

00:02:27.489 --> 00:02:30.030 align:start position:0%
well access can group the records with
the<00:02:27.610><c> same</c><00:02:27.640><c> book</c><00:02:28.209><c> ID</c><00:02:28.450><c> and</c><00:02:29.170><c> give</c><00:02:29.410><c> us</c><00:02:29.530><c> a</c><00:02:29.650><c> count</c><00:02:29.950><c> for</c>

00:02:30.030 --> 00:02:30.040 align:start position:0%
the same book ID and give us a count for
 

00:02:30.040 --> 00:02:33.390 align:start position:0%
the same book ID and give us a count for
each<00:02:30.400><c> one</c><00:02:30.760><c> to</c><00:02:31.080><c> do</c><00:02:32.080><c> that</c><00:02:32.110><c> let's</c><00:02:32.709><c> go</c><00:02:32.890><c> back</c><00:02:33.190><c> to</c>

00:02:33.390 --> 00:02:33.400 align:start position:0%
each one to do that let's go back to
 

00:02:33.400 --> 00:02:38.729 align:start position:0%
each one to do that let's go back to
design<00:02:33.550><c> view</c><00:02:34.180><c> and</c><00:02:36.390><c> click</c><00:02:37.390><c> the</c><00:02:37.600><c> totals</c><00:02:37.989><c> command</c>

00:02:38.729 --> 00:02:38.739 align:start position:0%
design view and click the totals command
 

00:02:38.739 --> 00:02:41.400 align:start position:0%
design view and click the totals command
this<00:02:39.069><c> makes</c><00:02:39.430><c> mints</c><00:02:39.730><c> hire</c><00:02:40.000><c> new</c><00:02:40.299><c> row</c><00:02:40.569><c> the</c><00:02:40.989><c> total</c>

00:02:41.400 --> 00:02:41.410 align:start position:0%
this makes mints hire new row the total
 

00:02:41.410 --> 00:02:43.380 align:start position:0%
this makes mints hire new row the total
row<00:02:41.590><c> it</c><00:02:41.860><c> appears</c><00:02:42.519><c> in</c><00:02:42.670><c> the</c><00:02:42.730><c> query</c><00:02:43.000><c> design</c>

00:02:43.380 --> 00:02:43.390 align:start position:0%
row it appears in the query design
 

00:02:43.390 --> 00:02:47.220 align:start position:0%
row it appears in the query design
window<00:02:44.340><c> now</c><00:02:45.340><c> by</c><00:02:45.519><c> default</c><00:02:45.600><c> this</c><00:02:46.600><c> row</c><00:02:46.930><c> sets</c>

00:02:47.220 --> 00:02:47.230 align:start position:0%
window now by default this row sets
 

00:02:47.230 --> 00:02:51.360 align:start position:0%
window now by default this row sets
everything<00:02:47.890><c> to</c><00:02:48.160><c> group</c><00:02:48.430><c> by</c><00:02:48.790><c> something</c><00:02:50.220><c> but</c><00:02:51.220><c> all</c>

00:02:51.360 --> 00:02:51.370 align:start position:0%
everything to group by something but all
 

00:02:51.370 --> 00:02:53.340 align:start position:0%
everything to group by something but all
we're<00:02:51.519><c> really</c><00:02:51.700><c> concerns</c><00:02:52.120><c> with</c><00:02:52.480><c> is</c><00:02:52.780><c> the</c><00:02:53.080><c> count</c>

00:02:53.340 --> 00:02:53.350 align:start position:0%
we're really concerns with is the count
 

00:02:53.350 --> 00:02:56.910 align:start position:0%
we're really concerns with is the count
so<00:02:53.890><c> that's</c><00:02:54.069><c> what</c><00:02:54.220><c> we're</c><00:02:54.340><c> going</c><00:02:54.489><c> to</c><00:02:54.519><c> change</c><00:02:55.920><c> now</c>

00:02:56.910 --> 00:02:56.920 align:start position:0%
so that's what we're going to change now
 

00:02:56.920 --> 00:03:00.570 align:start position:0%
so that's what we're going to change now
and<00:02:57.280><c> the</c><00:02:57.400><c> total</c><00:02:57.819><c> sell</c><00:02:58.120><c> for</c><00:02:58.959><c> book</c><00:02:59.200><c> ID</c><00:02:59.549><c> click</c><00:03:00.549><c> on</c>

00:03:00.570 --> 00:03:00.580 align:start position:0%
and the total sell for book ID click on
 

00:03:00.580 --> 00:03:04.110 align:start position:0%
and the total sell for book ID click on
the<00:03:00.819><c> drop-down</c><00:03:01.150><c> and</c><00:03:01.810><c> select</c><00:03:02.080><c> count</c><00:03:03.060><c> this</c><00:03:04.060><c> is</c>

00:03:04.110 --> 00:03:04.120 align:start position:0%
the drop-down and select count this is
 

00:03:04.120 --> 00:03:06.960 align:start position:0%
the drop-down and select count this is
how<00:03:04.420><c> we</c><00:03:04.480><c> tell</c><00:03:05.069><c> access</c><00:03:06.069><c> to</c><00:03:06.250><c> count</c><00:03:06.489><c> the</c><00:03:06.640><c> number</c>

00:03:06.960 --> 00:03:06.970 align:start position:0%
how we tell access to count the number
 

00:03:06.970 --> 00:03:09.120 align:start position:0%
how we tell access to count the number
of<00:03:07.000><c> times</c><00:03:07.120><c> each</c><00:03:07.720><c> book</c><00:03:08.200><c> ID</c><00:03:08.410><c> appears</c><00:03:08.920><c> in</c><00:03:09.070><c> the</c>

00:03:09.120 --> 00:03:09.130 align:start position:0%
of times each book ID appears in the
 

00:03:09.130 --> 00:03:13.770 align:start position:0%
of times each book ID appears in the
orders<00:03:09.430><c> table</c><00:03:09.840><c> now</c><00:03:10.840><c> when</c><00:03:11.109><c> we</c><00:03:11.230><c> click</c><00:03:11.410><c> run</c><00:03:12.780><c> we</c>

00:03:13.770 --> 00:03:13.780 align:start position:0%
orders table now when we click run we
 

00:03:13.780 --> 00:03:15.360 align:start position:0%
orders table now when we click run we
get<00:03:13.959><c> a</c><00:03:13.989><c> column</c><00:03:14.500><c> that</c><00:03:14.590><c> tells</c><00:03:14.650><c> us</c><00:03:15.070><c> how</c><00:03:15.310><c> many</c>

00:03:15.360 --> 00:03:15.370 align:start position:0%
get a column that tells us how many
 

00:03:15.370 --> 00:03:17.550 align:start position:0%
get a column that tells us how many
times<00:03:15.609><c> each</c><00:03:16.180><c> book</c><00:03:16.600><c> has</c><00:03:16.630><c> appeared</c><00:03:17.290><c> in</c><00:03:17.440><c> the</c>

00:03:17.550 --> 00:03:17.560 align:start position:0%
times each book has appeared in the
 

00:03:17.560 --> 00:03:20.190 align:start position:0%
times each book has appeared in the
orders<00:03:17.859><c> table</c><00:03:18.100><c> it</c><00:03:18.640><c> has</c><00:03:19.150><c> groups</c><00:03:19.600><c> each</c><00:03:19.810><c> book's</c>

00:03:20.190 --> 00:03:20.200 align:start position:0%
orders table it has groups each book's
 

00:03:20.200 --> 00:03:23.190 align:start position:0%
orders table it has groups each book's
title<00:03:20.350><c> author</c><00:03:20.920><c> price</c><00:03:21.519><c> and</c><00:03:21.790><c> category</c><00:03:22.450><c> to</c><00:03:22.959><c> show</c>

00:03:23.190 --> 00:03:23.200 align:start position:0%
title author price and category to show
 

00:03:23.200 --> 00:03:26.069 align:start position:0%
title author price and category to show
up<00:03:23.410><c> only</c><00:03:23.739><c> one</c><00:03:24.070><c> time</c><00:03:24.340><c> in</c><00:03:24.370><c> the</c><00:03:24.760><c> results</c><00:03:25.269><c> and</c><00:03:25.420><c> it</c>

00:03:26.069 --> 00:03:26.079 align:start position:0%
up only one time in the results and it
 

00:03:26.079 --> 00:03:27.870 align:start position:0%
up only one time in the results and it
shows<00:03:26.290><c> us</c><00:03:26.470><c> a</c><00:03:26.560><c> number</c><00:03:26.890><c> of</c><00:03:26.980><c> times</c><00:03:27.250><c> the</c><00:03:27.489><c> book</c><00:03:27.700><c> ID</c>

00:03:27.870 --> 00:03:27.880 align:start position:0%
shows us a number of times the book ID
 

00:03:27.880 --> 00:03:31.650 align:start position:0%
shows us a number of times the book ID
appears<00:03:28.450><c> in</c><00:03:28.630><c> the</c><00:03:28.720><c> orders</c><00:03:29.019><c> table</c><00:03:30.420><c> now</c><00:03:31.420><c> if</c><00:03:31.540><c> you</c>

00:03:31.650 --> 00:03:31.660 align:start position:0%
appears in the orders table now if you
 

00:03:31.660 --> 00:03:33.420 align:start position:0%
appears in the orders table now if you
pay<00:03:31.810><c> close</c><00:03:32.019><c> attention</c><00:03:32.290><c> you'll</c><00:03:32.980><c> notice</c><00:03:33.069><c> that</c>

00:03:33.420 --> 00:03:33.430 align:start position:0%
pay close attention you'll notice that
 

00:03:33.430 --> 00:03:35.699 align:start position:0%
pay close attention you'll notice that
the<00:03:33.549><c> last</c><00:03:33.790><c> column</c><00:03:34.390><c> says</c><00:03:34.600><c> counts</c><00:03:35.140><c> of</c><00:03:35.290><c> book</c><00:03:35.470><c> ID</c>

00:03:35.699 --> 00:03:35.709 align:start position:0%
the last column says counts of book ID
 

00:03:35.709 --> 00:03:37.349 align:start position:0%
the last column says counts of book ID
but<00:03:36.519><c> in</c><00:03:36.640><c> design</c><00:03:36.970><c> view</c>

00:03:37.349 --> 00:03:37.359 align:start position:0%
but in design view
 

00:03:37.359 --> 00:03:41.130 align:start position:0%
but in design view
it<00:03:37.569><c> just</c><00:03:37.840><c> said</c><00:03:38.049><c> book</c><00:03:38.620><c> ID</c><00:03:38.950><c> I</c><00:03:39.840><c> just</c><00:03:40.840><c> wanted</c><00:03:41.019><c> to</c>

00:03:41.130 --> 00:03:41.140 align:start position:0%
it just said book ID I just wanted to
 

00:03:41.140 --> 00:03:42.300 align:start position:0%
it just said book ID I just wanted to
point<00:03:41.319><c> that</c><00:03:41.440><c> out</c><00:03:41.560><c> so</c><00:03:41.890><c> it</c><00:03:41.980><c> wouldn't</c><00:03:42.190><c> be</c>

00:03:42.300 --> 00:03:42.310 align:start position:0%
point that out so it wouldn't be
 

00:03:42.310 --> 00:03:47.460 align:start position:0%
point that out so it wouldn't be
confusing<00:03:43.440><c> now</c><00:03:45.480><c> we</c><00:03:46.480><c> can</c><00:03:46.660><c> go</c><00:03:46.840><c> back</c><00:03:46.870><c> and</c><00:03:47.319><c> change</c>

00:03:47.460 --> 00:03:47.470 align:start position:0%
confusing now we can go back and change
 

00:03:47.470 --> 00:03:49.680 align:start position:0%
confusing now we can go back and change
the<00:03:47.680><c> design</c><00:03:48.040><c> of</c><00:03:48.310><c> the</c><00:03:48.400><c> query</c><00:03:48.760><c> to</c><00:03:49.180><c> sort</c><00:03:49.510><c> the</c>

00:03:49.680 --> 00:03:49.690 align:start position:0%
the design of the query to sort the
 

00:03:49.690 --> 00:03:53.280 align:start position:0%
the design of the query to sort the
count<00:03:49.989><c> highest</c><00:03:50.560><c> to</c><00:03:50.739><c> lowest</c><00:03:50.769><c> or</c><00:03:51.840><c> descending</c><00:03:52.840><c> so</c>

00:03:53.280 --> 00:03:53.290 align:start position:0%
count highest to lowest or descending so
 

00:03:53.290 --> 00:03:55.140 align:start position:0%
count highest to lowest or descending so
we<00:03:53.380><c> can</c><00:03:53.560><c> see</c><00:03:53.739><c> which</c><00:03:53.980><c> books</c><00:03:54.190><c> were</c><00:03:54.370><c> ordered</c><00:03:54.639><c> most</c>

00:03:55.140 --> 00:03:55.150 align:start position:0%
we can see which books were ordered most
 

00:03:55.150 --> 00:03:59.940 align:start position:0%
we can see which books were ordered most
at<00:03:55.420><c> the</c><00:03:55.660><c> top</c><00:03:58.049><c> we</c><00:03:59.049><c> could</c><00:03:59.200><c> also</c><00:03:59.380><c> change</c><00:03:59.739><c> the</c>

00:03:59.940 --> 00:03:59.950 align:start position:0%
at the top we could also change the
 

00:03:59.950 --> 00:04:02.069 align:start position:0%
at the top we could also change the
design<00:04:00.100><c> see</c><00:04:00.489><c> filter</c><00:04:00.970><c> for</c><00:04:01.180><c> certain</c><00:04:01.450><c> categories</c>

00:04:02.069 --> 00:04:02.079 align:start position:0%
design see filter for certain categories
 

00:04:02.079 --> 00:04:03.840 align:start position:0%
design see filter for certain categories
if<00:04:02.319><c> we</c><00:04:02.680><c> wanted</c><00:04:02.950><c> to</c><00:04:03.100><c> know</c><00:04:03.250><c> what</c><00:04:03.639><c> technology</c>

00:04:03.840 --> 00:04:03.850 align:start position:0%
if we wanted to know what technology
 

00:04:03.850 --> 00:04:06.629 align:start position:0%
if we wanted to know what technology
titles<00:04:04.600><c> sell</c><00:04:04.840><c> the</c><00:04:04.989><c> best</c><00:04:05.230><c> for</c><00:04:05.530><c> example</c><00:04:06.010><c> the</c>

00:04:06.629 --> 00:04:06.639 align:start position:0%
titles sell the best for example the
 

00:04:06.639 --> 00:04:09.240 align:start position:0%
titles sell the best for example the
back<00:04:06.850><c> in</c><00:04:07.000><c> our</c><00:04:07.150><c> query</c><00:04:07.480><c> design</c><00:04:07.870><c> view</c><00:04:08.230><c> we</c><00:04:08.500><c> add</c><00:04:09.010><c> the</c>

00:04:09.240 --> 00:04:09.250 align:start position:0%
back in our query design view we add the
 

00:04:09.250 --> 00:04:11.640 align:start position:0%
back in our query design view we add the
criteria<00:04:09.910><c> of</c><00:04:10.060><c> technology</c><00:04:10.840><c> for</c><00:04:11.109><c> the</c><00:04:11.169><c> category</c>

00:04:11.640 --> 00:04:11.650 align:start position:0%
criteria of technology for the category
 

00:04:11.650 --> 00:04:16.110 align:start position:0%
criteria of technology for the category
field<00:04:13.769><c> this</c><00:04:14.769><c> whole</c><00:04:15.130><c> row</c><00:04:15.430><c> is</c><00:04:15.579><c> called</c><00:04:15.760><c> carts</c>

00:04:16.110 --> 00:04:16.120 align:start position:0%
field this whole row is called carts
 

00:04:16.120 --> 00:04:16.360 align:start position:0%
field this whole row is called carts
here

00:04:16.360 --> 00:04:16.370 align:start position:0%
here
 

00:04:16.370 --> 00:04:18.310 align:start position:0%
here
it<00:04:16.760><c> filters</c><00:04:17.209><c> your</c><00:04:17.329><c> data</c><00:04:17.540><c> based</c><00:04:17.959><c> on</c><00:04:18.199><c> the</c>

00:04:18.310 --> 00:04:18.320 align:start position:0%
it filters your data based on the
 

00:04:18.320 --> 00:04:23.950 align:start position:0%
it filters your data based on the
criteria<00:04:18.919><c> you</c><00:04:19.160><c> set</c><00:04:19.489><c> here</c><00:04:22.330><c> now</c><00:04:23.330><c> let's</c><00:04:23.570><c> say</c><00:04:23.780><c> this</c>

00:04:23.950 --> 00:04:23.960 align:start position:0%
criteria you set here now let's say this
 

00:04:23.960 --> 00:04:26.850 align:start position:0%
criteria you set here now let's say this
query<00:04:24.380><c> is</c><00:04:24.590><c> our</c><00:04:24.740><c> best</c><00:04:25.130><c> sellers</c><00:04:25.610><c> by</c><00:04:25.820><c> category</c><00:04:26.449><c> so</c>

00:04:26.850 --> 00:04:26.860 align:start position:0%
query is our best sellers by category so
 

00:04:26.860 --> 00:04:29.620 align:start position:0%
query is our best sellers by category so
now<00:04:27.860><c> you've</c><00:04:28.070><c> seen</c><00:04:28.100><c> how</c><00:04:28.639><c> you</c><00:04:28.699><c> can</c><00:04:28.850><c> create</c><00:04:29.240><c> and</c>

00:04:29.620 --> 00:04:29.630 align:start position:0%
now you've seen how you can create and
 

00:04:29.630 --> 00:04:31.600 align:start position:0%
now you've seen how you can create and
modify<00:04:29.930><c> queries</c><00:04:30.470><c> and</c><00:04:30.770><c> orders</c><00:04:31.040><c> to</c><00:04:31.130><c> answer</c><00:04:31.520><c> the</c>

00:04:31.600 --> 00:04:31.610 align:start position:0%
modify queries and orders to answer the
 

00:04:31.610 --> 00:04:33.280 align:start position:0%
modify queries and orders to answer the
questions<00:04:32.000><c> you</c><00:04:32.180><c> may</c><00:04:32.360><c> have</c><00:04:32.389><c> about</c><00:04:32.840><c> your</c><00:04:32.900><c> data</c>

00:04:33.280 --> 00:04:33.290 align:start position:0%
questions you may have about your data
 

00:04:33.290 --> 00:04:36.070 align:start position:0%
questions you may have about your data
but<00:04:34.130><c> you</c><00:04:34.250><c> also</c><00:04:34.520><c> saw</c><00:04:35.000><c> that</c><00:04:35.210><c> the</c><00:04:35.300><c> data</c><00:04:35.570><c> that</c><00:04:35.930><c> is</c>

00:04:36.070 --> 00:04:36.080 align:start position:0%
but you also saw that the data that is
 

00:04:36.080 --> 00:04:38.469 align:start position:0%
but you also saw that the data that is
returned<00:04:36.530><c> doesn't</c><00:04:37.160><c> look</c><00:04:37.280><c> very</c><00:04:37.310><c> nice</c><00:04:37.760><c> if</c><00:04:38.330><c> you</c>

00:04:38.469 --> 00:04:38.479 align:start position:0%
returned doesn't look very nice if you
 

00:04:38.479 --> 00:04:40.270 align:start position:0%
returned doesn't look very nice if you
have<00:04:38.630><c> to</c><00:04:38.810><c> formally</c><00:04:39.290><c> share</c><00:04:39.710><c> them</c><00:04:39.919><c> with</c><00:04:39.949><c> someone</c>

00:04:40.270 --> 00:04:40.280 align:start position:0%
have to formally share them with someone
 

00:04:40.280 --> 00:04:42.969 align:start position:0%
have to formally share them with someone
else<00:04:40.669><c> our</c><00:04:41.449><c> next</c><00:04:41.930><c> lesson</c><00:04:42.320><c> will</c><00:04:42.470><c> show</c><00:04:42.500><c> you</c><00:04:42.710><c> how</c>

00:04:42.969 --> 00:04:42.979 align:start position:0%
else our next lesson will show you how
 

00:04:42.979 --> 00:04:45.340 align:start position:0%
else our next lesson will show you how
to<00:04:43.010><c> run</c><00:04:43.280><c> reports</c><00:04:43.310><c> and</c><00:04:43.910><c> have</c><00:04:44.330><c> a</c><00:04:44.389><c> format</c><00:04:44.930><c> them</c><00:04:45.139><c> to</c>

00:04:45.340 --> 00:04:45.350 align:start position:0%
to run reports and have a format them to
 

00:04:45.350 --> 00:04:48.699 align:start position:0%
to run reports and have a format them to
look<00:04:45.500><c> good</c><00:04:45.740><c> to</c><00:04:45.979><c> other</c><00:04:46.190><c> people</c>