Table: subnotebooks_specs
Columns: model
manufacturer
weight_kg
display_size_in
processor_model
storage_type

Question: Which Weight (kg) has a Manufacturer of fujitsu, and a Model of lifebook p1610?
SQL: SELECT AVG("weight_kg") FROM subnotebooks_specs WHERE "manufacturer" = 'fujitsu' AND "model" = 'lifebook p1610'

Question: Which Display size (in) has a Model of versapro vy10f/bh-l?
SQL: SELECT MIN("display_size_in") FROM subnotebooks_specs WHERE "model" = 'versapro vy10f/bh-l'

Question: Which Display size (in) has a Model of vaio pcg-u3?
SQL: SELECT COUNT("display_size_in") FROM subnotebooks_specs WHERE "model" = 'vaio pcg-u3'