Table: precision_specs
Columns: model
fsb_mhz
chipset
memory
graphics

Question: Which model(s) has AGP graphics and 400 FSB (MHz)?
SQL: SELECT "model" FROM precision_specs WHERE "graphics" = 'agp' AND "fsb_mhz" = '400'

Question: Which model's chipset is intel 955?
SQL: SELECT "memory" FROM precision_specs WHERE "chipset" = 'intel 955'

Question: What is the chipset in the Precision 340 model that has the rambus memory and 400 or 533 FSB (MHz)?
SQL: SELECT "chipset" FROM precision_specs WHERE "memory" = 'rambus' AND "fsb_mhz" = '400 or 533' AND "model" = 'precision 340'

Question: What type of graphics are present in the Precision 340 model with the intel 850e chipset?
SQL: SELECT "graphics" FROM precision_specs WHERE "chipset" = 'intel 850e' AND "model" = 'precision 340'

Question: What type of chipset is in the Precision t3400 model with the PCI Express graphics?
SQL: SELECT "chipset" FROM precision_specs WHERE "graphics" = 'pci express' AND "model" = 'precision t3400'