Write a query to count retweet and tweets. The output table should contain columns 'type' and 'count'. For retweeted type $=$ 'retweet' otherwise type $=$ 'not retweet' for tweets which are never retweeted. Try using Case statement. 'count' is the count of retweets$/$retweets$.$

Tables Schema as Below:

UserTweetRelation

columnName dataType

id INT

created$\_$at DATE

retweet VARCHAR$(50)$

user$\_$id INT

tweet$\_$id INT

Input