I gang

Write SQL queries


Require a person who deals in databases with high knowledge for writing complex queries.

All info in the files. with the 3 tables . sql file

I need the person write to me 2 sql queries.

query one: search on showtimes where the movieID is what i give him for example 88, then i show me only 3 Thearters are show time movie. i need the dates from showtimes broken by sign # like

vtid (theaterID) | vt_name (theaterName) | vs_dates (times)

6 | some name | 1222222#1333333#144444

7 | other theater | 1222222#13113333#141144

9 | other theater2 | 1222442#133113#143344

i added photos just watch them.

query two:

same search but with TheaterID.. not movieid like first.

Evner: Database Administration, MySQL, PHP, SQL

Se mere: Writing SQL Queries, write query, sql queries, queries, mysql to sql, php sql complex, php mysql sql example, write sql queries, movie write, mysql query example, mysql php search dates, sql file, write sql , complex mysql query, write photos, write time file, tree queries sql, sql write time project, sql write back excel addin, sql movie theater

Om arbejdsgiveren:
( 6 bedømmelser ) Kfar Saba, Israel

Projekt ID: #5810428

4 freelancere byder i gennemsnit $33 på dette job


A proposal has not yet been provided

$49 USD på 1 dag
(63 bedømmelser)

Hello, I have availability to start your job as soon as possible. Feel free to chat me and see details. If you have any question, please feel free to ask me. Yours Sincerely, Eduardo

$29 USD på 1 dag
(13 bedømmelser)

Can complete it immediately. Payment can be made via milestone and you can complete it after testing the solution fully on your machine. Looking forward to hearing from you

$30 USD in 0 dage
(17 bedømmelser)

A proposal has not yet been provided

$25 USD på 1 dag
(0 bedømmelser)