sql query of paid and star rating logic

Question

two tables are there one starrating and one paidmember table.

 

ID	paid
1	1
2	1
3	0
4	1
5	1
6	1

 

ID	star
1	6
2	6
3	6
4	5
5	6
6	3

 

 

 

if star will be 6 and paid=1 it shows first if paid=0 and rating 6 it show last then check the star 5 same logic