select title, author 
from dbo.book
where title like 'C%'


select title, author 
from dbo.book
where title like 'C%'
and (author like 'T%' or author like 'S%')


select top 10 *
from dbo.book 
order by author

select top 50 percent *
from dbo.book 
order by author

select  scity                -- How would we eliminate duplicates
from dbo.student
order by 1