SQL programs

Data

Name num models made public in 2006

Description

SQL Program select count(*) from objects datemodelpublic, eav_int serialno, objects model where datemodelpublic.object_id=serialno.object_id and datemodelpublic.object_class=127 and datemodelpublic.object_name=model.object_id and datemodelpublic.object_description like '2006%'

Maximum Rows

Maximum Columns