How to write a database query in Yii?

Question

MySQL

There is a News table in Mysql
id name date
1 title1 18.12
2 title2 19.12
3 title3 19.12
You need to use Yii to write a query that groups news by date and includes the CPadination property to display news by the number of dates on one page.
The output should be:
1) 18.12 title1
2) 19.12 title2
title3

Answer 1

Maybe Yii took up early? learn the basics and stuff first?

Answer 2

Made.