-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M');
INSERT INTO students VALUES (2, 'Joanna', 'F');
-- fetch some values
-- SELECT * FROM students WHERE gender = 'F';
select Substring(‘ASSAFETIDA’, -4, 4);
SELECT POWER(Round( 229.7894,0) * 10,-2);
SELECT ROUND(229.7894,0);