TEKsystems interview question

write some sql queries regarding count,distinct,between,join