Day 2 AMPscript Data Extension to Cloud Page

To display data from Data Extension(SQL Table) into Cloud Page(web-page) using AMPscript Functions Needed : Lookuprows, Rowcount, Row, Field Conditional statement : IF ELSE Loop or Iterator : FOR loop a)Display one record from Data Extension based on Email Aaddress b)Display records(more than one) based on field with boolean value (true or false)