[Koha] (no subject)

Hello Can anyone please send me sql for subject-wise report of titles with author name, no. of copies, subject name in serialized listing? If anyone sends me it's really helpful for me. Thanking You