Let's say I have a BOOK table.

with this structure:

```
create table BOOK (
  AUTHOR varchar2(100),
  TITLE  varchar2(100)
);

```

What I want to do is to check/(or count, count(\*) = 1) whether a book with author = 'John Smith' exists, and whether there exists a book authored by 'John Smith' starting with the letter 'T'.

I came up with two SQL statements.

```
select count(1)
  from BOOK
 where AUTHOR = 'John Snow'
   and rownum = 1

select count(1)
  from BOOK
 where AUTHOR = 'John Snow'
   and TITLE like = 'T%'
   and rownum = 1

```

My question is: Is there a way such that I can know whether a book of such criteria exists (I need to know whether there is a book by John Snow and whether he wrote a book with a title starting with the letter 'T') by performing only 1 query? Such that performing this 1 query will be faster than performing the 2 queries from above? Thanks!