They are almost correct, only that what you are missing is that the format of SELECT COUNT(*) query in SQL is formatted not as you did.

Example in query one it should be

SELECT COUNT(bookname)

FROM publisher

WHERE date

BETWEEN '2017/06/01' AND '2017/06/30'

Else they are correct.

Wish you the best.

 

Another question to clarify....So I need to use the above format SELECT COUNT(*) for the rest of my queries, is that correct? For example number 2. I put

 

SELECT authorname (count), bookname

FROM product

WHERE date.publisher

BETWEEN '2017/06/01' AND '2017/06/30'

 

but it actually should be

 

SELECT COUNT (authorname), bookname

FROM product

WHERE date.publisher

BETWEEN '2017/06/01' AND '2017/06/30'

 

Is that the correct format you are talking about that I need to use for the rest of my queries?

SophiaPretty

(5)

Status NEW Posted 22 Nov 2017 01:11 PM My Price 7.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer