question

akashbisht81 avatar image
akashbisht81 asked

Get the list of all the (reviews and papers) which has been reviewed by reviewer and also get the author name for that list of the paper.

Schema :

AUTHOR:{a_id,a_first_name,a_last_name,a_phone_no,a_email,a_pwd}

PAPER: {paper_id,title,abstract,file_name,author_id}

REVIEWER:{rvr_id,rvr_first_name,rvr_last_name,rvr_phone,rvr_email,rvr_pwd,rvr_interest}

REVIEW:{rv_id,clarity,relevance,technical_rate,rvr_id,paper_id}

**THIS IS A BIT INTIMIDATING FOR ME**

THANK YOU VERY MUCH. GOD BLESS YOU.


sqlquerydatabasemysqlquery-results
10 |1200 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
akashbisht81 avatar image
akashbisht81 answered

solved it Here is the query for this question :-- Is there any other way to solve it ?

select a.a_first_name,p.title, rr.rvr_first_name,r.rv_id,r.clarity,r.relevance,r.technical_rate

from review r

join reviewer rr on rr.rvr_id = r.Rrvr_id

join paper p on r.p_id = p.paper_id

join author a on p.author_id = a.a_id;





capture.jpg (20.8 KiB)
10 |1200 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.