HomePagev2 Forums SQL Discussions sql assignment1

  • sql assignment1

  • tej

    Member
    February 3, 2021 at 10:43 am

    Help me with these queries

    Solve the following:

    Give all the countries and continents where the First Letter Matches

    Give all the countries and continents where the Last Letter does not match

    Solve the following:Country code with the most Spanish speaking region and what percentage is Spanish

    What % of the world speaks Spanish

  • shivakrishna

    Member
    February 3, 2021 at 4:55 pm

    Sample table and clear questions with examples please!!

  • Satish Vadlamani

    Administrator
    February 4, 2021 at 12:29 pm

    @tej like what @shiva asked,can you please provide a sample tables and data

  • Karri Bindu Madhavi

    Member
    April 21, 2021 at 2:29 pm

    Hello everyone,

    In sql practice1,i found this question

    “Find the country that has all the vowels and no spaces in its name?”

    and i wrote a query like this

    “””

    select name from country

    where name like ‘%a%’ and

    name like ‘%e%’ and

    name like ‘%i%’ and

    name like ‘%o%’ and

    name like ‘%u%’ and

    name not like ‘% %’

    “””

    the correct output is the “mozambique”,which is a country name include all vowels and no spaces in it ,but after executing the above query it doesn’t give any output

    can anyone help with this query?

    Thank you

  • Satish Vadlamani

    Administrator
    April 22, 2021 at 10:26 pm

    @Bindu Did you try trimming the column. Rtrim(ltrim( colname))

Log in to reply.

Original Post
0 of 0 posts June 2018
Now