Lines Matching refs:name

23     name TEXT PRIMARY KEY,
62   SELECT name FROM people WHERE height>=180 ORDER BY +name;
66   SELECT name FROM people WHERE height>=180 ORDER BY +name;
82   SELECT name FROM people WHERE height>=180 ORDER BY +name;
86   SELECT name FROM people WHERE height>=180 ORDER BY +name;
92   SELECT name FROM people
94      AND height>=180 ORDER BY +name;
97   SELECT name FROM people WHERE role='teacher' AND height>=180
99   SELECT name FROM people WHERE role='student' AND height>=180
121   SELECT name FROM people WHERE height>=180 ORDER BY +name;
125   SELECT name FROM people WHERE height>=180 ORDER BY +name;
140   SELECT name FROM people WHERE height>=180 ORDER BY +name;
144   SELECT name FROM people WHERE height>=180 ORDER BY +name;
152     name TEXT PRIMARY KEY,
158   INSERT INTO peoplew(name,role,height)
159      SELECT name, role, height FROM  people;
160   SELECT name FROM peoplew WHERE height>=180 ORDER BY +name;
163   SELECT name FROM peoplew
165      AND height>=180 ORDER BY +name;
168   SELECT name FROM peoplew WHERE role='teacher' AND height>=180
170   SELECT name FROM peoplew WHERE role='student' AND height>=180
181   SELECT name FROM peoplew WHERE height>=180 ORDER BY +name;
185   SELECT name FROM peoplew WHERE height>=180 ORDER BY +name;