How to create a DB/table and write data to SQLite react-native+expo?

Question

SQLite

I have never used sql, so I need help in creating a database of tables, writing data to it and reading from it.

Answer 1

DDL command to create a table:

Create table TABLE_SKILLS (
                        ID integer primary key autoincrement,
                        NAME text NOT NULL, PROGRESS text DEFAULT '00:00:00' NOT NULL);

DML command to write data: DML command to receive data:
Select * From TABLE_SKILLS;