5 rows where score = 1 sorted by variable

View and edit SQL

score

Link rowid project_number variable ▼ score
9 1 Business viability 1
11 1 Environmental Co-benefits 1
4 1 Legitimacy 1
12 1 Mitigation synergies 1
7 1 Social Co-benefits 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "case_study" (
	"project_number" VARCHAR(100) NULL,
	"variable" VARCHAR(100) NULL,
	"score" INTEGER NULL
);