Queries

Queries:
Query 1: Samsung phones
 * Showing only the Samsung phones
 * Displaying the fields: Phone, Dimensions, release date

Query 2: Good batteries
 * Phones with a battery life bigger than 400 mins
 * All fields

Query 3: Android phones
 * Phones with an android OS
 * Giving only the brand and the phone name

media type="file" key="query_3.swf" width="945" height="945" [|query_3.swf]

Query 4: Cheap phones
 * 512 MB Ram
 * Less than 200 usd
 * All fields

Query 5:10 times smart
 * A new field called: “Your Price” that multiplies the price times ten
 * Showing the fields: Phone, brand, price, release date, your price

Query 6: Magic letter A
 * Show all the fields of the phones that have a letter A in the brand name

 Query 7: Phone and brand name
 * Create a new field “Full name” that combines the brand and the phone name
 * The fields “Full name” and price are visible.

Query 8:New phones
 * Find all phones that came out this year (2010)

Query 9: Older phones
 * Phones that came out between January 2010 and May 2010