bobbyiliev / introduction-to-sql Goto Github PK

Is your feature request related to a problem? Please describe.

Between Operator not present in where.md

Describe the solution you'd like

I would add that with example

Additional context

I would like to add this as part of Hactoberfest 2021

Hi ,

There is a scope of improvement in the insert.md file.
More use cases can be added along with examples.

I would like to contribute for the same.
Kindly assign this issue to me.

Is your feature request related to a problem? Please describe.

The section 005-select.md would deserve a mention of basic pattern matching using LIKE and ILIKE operators.

Describe the solution you'd like

Add another section called "Pattern matching" to 005-select.md explaining how to use LIKE and ILIKE.

Additional context

Can you assign this to me?

https://sql.bobby.sh/

Hi ,

There is a scope of improvement in the order-and-group-by.md file.
More use cases can be added along with examples.

I would like to contribute for the same.
Kindly assign this issue to me.

Note :- I have added some examples and use cases and raised a PR for the same.
PR Link :- Introduced HAVING Clause to filter out the groups created by GROUP BY Clause

Hi ,

There is a scope of improvement in the select.md file.
More use cases can be added along with examples.

I would like to contribute for the same.
Kindly assign this issue to me.

Note :- I have added some examples and use cases and raised a PR for the same.

File Location/Types in Contributing.md doesn't match the current project structure will update that.

To Reproduce

1.Visit : This
There are no translations of the book present in the repo now will change it as per the current structure.

Expected behavior

Current structure explanation

Screenshots

Additional context

I Will work on it as part of Hacktoberfest 2021

Hi ,

There is a scope of improvement in the join.md file.
Different types of Inner Join can be added with use cases.

I would like to contribute for the same.
Kindly assign this issue to me.

Note :- I have added some examples and use cases and raised a PR for the same.
PR Link :- Added Information about different types of INNER join with use cases

Data Control Language Commands

• Grant

• Revoke

Kindly assign this to me.

Is your feature request related to a problem? Please describe.

Links to chapters are not added.

Describe the solution you'd like

Adding links to chapters in README.md

Additional context

please consider this for Hacktoberfest 2021.

Is your feature request related to a problem? Please describe.

creating-tables Chapter does not describe how to rename a table

Describe the solution you'd like

Add rename table point along with example

Additional context

Contributing as part of Hactoberest 2021

Transaction Control Language commands

• Commit

• Rollback

• Savepoint

Please assign this to me.

Is your feature request related to a problem? Please describe.

want to add about truncate table in table chapter

Describe the solution you'd like

The TRUNCATE TABLE command deletes the data inside a table, but not the table itself.

Additional context

contributing to hacktoberfest 2021

Is your feature request related to a problem? Please describe.

Create table Chapter don't include point of How to create a new table from existing table

Describe the solution you'd like

I would like to add the point with an example.
Syntax of it
CREATE TABLE new_table AS (SELECT * FROM old_table);

Additional context

Want to contribute as part of Hacktoberfest 2021

Hi ,
There is a scope of improvement along with few issues in the readme.md file.
i would like to contribute to its betterment so please can you assign this issue to me