Help required writing a complex query

CREATE TABLE userneed_comparison_labels (
  id    integer PRIMARY KEY,
  name  char(50) NOT NULL
)

Select allOpen in new window

CREATE TABLE tbl_comparison_values (
  id                            integer PRIMARY KEY,
  tbl_content_common_id         integer NOT NULL,
  userneed_comparison_label_id  integer NOT NULL,
  value                         char(50) NOT NULL,
  
)

Select allOpen in new window

CREATE TABLE tbl_content_commons (
  id                               integer PRIMARY KEY,
  content_common_code              char(20) NOT NULL,
  content_common_name              char(100) NOT NULL,
  
)

Select allOpen in new window

I have three tables as shown above. From these tables, I am trying to generate a comparison table as shown in the attached image. For that, I need to write a query with the following requirements. Or experts can suggest queries after referring the attached screenshot and the tables defined above.

Conditions in my words:

1) Get all the name fields from userneed_comparison_labels using the userneed_comparison_label_id of tbl_comparison_values. At the same time, fetch the 'value' corresponding to the userneed_comparison_label_id

2) The input or the parameter would be tbl_content_common_id . This can vary from 2 to n number of id's at a time. Means user can compare any number of items at a time.

3) Preferrably, the result should be given in the order from most common userneed_comparison_label_id's for the given set of tbl_content_common_id's to the least common.

4) Preferrably, in the result, if a particular value is not available for a given tbl_content_common_id, then that value for that content should be denoted by "Not Available"

5) Finally, the name corresponding to tbl_content_common_id should be fetched from tbl_content_commons field content_common_name.


I prefer the result of the query is more close to the attached image of comparison table itself , if possible, so that things become much easier.

Any help in implementing this query would surely be well appreciated.

PS: I have attached the screenshot of the UI I am planning to implement once I have the above query. The sqlite db with three tables and some data is uploaded in this link > I am unable to attah .db file here!
comparison.bmp