Anyone good in SQL queries?

[Plague]

Could anyone help me build a script for this one? Sorry, I badly need help from you experts as it will me in school hehe.
Here is the attached image below.

You must be registered for see images attach

an sql script.
P.S Thank you admin/mod for considering this post.

 

[JayC]

Script to do what? Drop the table? Clear all records? Select items?