solve my sql query and provide me right method of doing it