<P> Reports and queries are the two primary forms of the retrieved data from a database . There are some overlaps between them, but queries generally select a relatively small portion of the database, while reports show larger amounts of data . Queries also present the data in a standard format and usually display it on the monitor; whereas reports allow formatting of the output however you like and is normally printed . </P> <P> Reports are designed using a report generator built into the DBMS . </P>

Explain in detail for data retrieval with examples