Programming language, such as JAVA, C, Python, and SQL, are commonly used in electronic health records and databases. Relational databases use structured query language (SQL) programming. SQL statements can be divided into two categories: data manipulation language (DML) and data definition language (DDL).

Compare and contrast data manipulation and definition language and provide an example and statement from each category.