database: json format and sqlite

[ibreeden]

With my programme I get the following (I suppose it is what I have to obtain):

Output:
('Mehraz', 'si310', 0)('Tobie', 'si310', 0)
('Naila', 'si310', 0)
('Asif', 'si310', 0)
('Derren', 'si310', 0)
('Abdulkadir', 'si310', 0)

I can't believe you get this result by executing:

Output:
SELECT User.name,Course.title, Member.role FROM 
    User JOIN Member JOIN Course 
    ON User.id = Member.user_id AND Member.course_id = Course.id
    ORDER BY User.name DESC, Course.title DESC, Member.role DESC LIMIT 2;

It says: "LIMIT 2" but you get 6 records. It also says "ORDER BY User.name DESC" but your names appear in random order.
Please have a sharp look at how you execute this query.