Microsoft Access Essential Queries

Example 1:
Select * from customers

Example 2:
select * from customers where Country ='uk'

Example 3:
select City,Country from customers order by city

Example 4:
select City,Country from customers order by 1

Example 5:
select distinct City,Country from customers order by 1

Example 6:
Select Count(*) from Customers where Country ='uk

Example 7:
Select sum(Quantity) from[order details] where productid = 11

Example 8:
Select productid, sum(Quantity) as sum_qty from [Order Details] group by productid

LED Blink ATmega32

here is the bascom code :

$regfile = "m32def.dat"
$crystal = 8000000
Config Portd = Output
Do
Portd.6 = 0
Waitms 500
Portd.6 = 1
Waitms 500
Loop
End

pin10 ---> vcc
pin11 ---> gnd
pin20 ---> led+resistor(470 ohm)