What sql statement will return all cities with countries where they are situated punët
Pershendetje Glen. Jam e interesuar per ndihmen tuaj ne SQL. Do te me duhet ndihma jote ne nje provim neser. A mundeni te me ndihmoni me nje shume prej 10 euro per 1 or e gjysem?
njerëzit kanë të drejtë të vendosin baste live
Programing in Dot Net & SQL Server. Visual Studio 2010, SQL Server 2012 Express ose më të avancuar. Modify existing modules, add modules, design interface, Reports...etc
, & are three very successful websites that sale high quality custom clothing labels in small quantities to several thousand SME as well as individuals who need to mark clothes with great good looking labels of professional quality. Since 2011, the business has enjoyed a steady growth of happy customer and an excellent track record of sales. Following this success we are now expanding to Russian speaking customers via a new website targeting Russia, Ukraine, Belarus and EU Baltic states such as Estonia, Latvia and Lithuania. We are seeking a dynamic eCommerce Manager to assure success again. Location: For training purposes, preferably (and initially) the ideal candidate should be based close to Tallinn, but this can be discussed. However
Canon Cameras: Canon EOS 7D 18MP Digital SLR Camera Canon EOS 50D 15MP DSLR Camera Canon EOS 60D Canon EOS Rebel T2i Canon 1D Mk IV Canon EOS-1Ds Mark III 21.1MP DSRL Camera Canon EOS 1Ds Mark II Body Canon EOS 600D 18MP Digital SLR Camera Canon EOS 1D Mark IV 16MP Digital SLR Camera Canon EOS 5D Mark II SLR CANON LENSES: Canon 10-22 mm EF-S f/3.5-4.5 USM Wide Angle Canon 100 mm EF f/2.8 Macro USM Canon 100-300 mm f/4.5-5.6 USM EF Canon 100-400 mm f/4.5-5.6L EF IS Canon 135 mm EF f/2.0 L USM Lens Canon 15 mm EF f/2.8 Fisheye Lens Canon 16-35 mm f/2.8L USM EF Zoom Canon 17-40 mm f/4 L USM EF Lens Canon Zoom lens - 70 mm - 200 mm - F/2.8 Canon 17-55 mm f/2.8 EF-S IS USM Wide Angle Zoom Canon 17-85 mm EF-S f/4-5.6 IS USM Lens Canon 180 mm EF f/3.5 L Macro USM Lens...
I'm looking to obtain contact information, specifically email addresses and physical addresses, of local jewellery shops from multiple countries. This information will be primarily used for a marketing campaign. The ideal freelancer for this job should possess: - Proficiency in web research and data collection - Proven experience in lead generation - Knowledge about the jewellery shop industry. I'm particularly interested in local artisans, as opposed to high-end luxury shops or exclusively online retailers. Please apply if you are confident in gathering accurate and quality data from various resources.
...**About Us:** We are a cutting-edge tech company dedicated to revolutionizing the music industry through innovative AI solutions. We aim to empower musicians, artists, and producers by providing them with advanced tools to enhance their creativity and productivity. **Job Description:** We are seeking a talented and experienced AI Developer to create an advanced AI Music Lyrics Generator. This bot will be capable of analyzing uploaded instrumentals and generating both the lyrical flow and content to match the music. The lyrics produced must be clean and suitable for audiences aged 18 and above. **Key Responsibilities:** - Develop and implement an AI system capable of generating music lyrics based on uploaded instrumentals. - Ensure the AI-generated lyrics ...
...doorsteps in GCC countries. - Efficient Handling Of Electronics & Clothes: You should be well-versed in handling electronic goods and clothes to ensure they reach their destination in optimal condition. - In-Depth Knowledge Of GCC Customs Regulations: You should be familiar with the customs regulations of Saudi Arabia, United Arab Emirates, Bahrain, Oman, Qatar, and Kuwait to ensure the smooth passage of the shipments. Ideal Candidate: - Proven experience in logistics and shipping, particularly with air freight. - A strong network in the logistics industry to secure competitive air-shipping rates. - Prior experience in handling electronics and clothes, with a clear understanding of the fragility of such goods. - Familiarity with customs ...
Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.
Hi, I'm Courtney Cunningham from Ride Candy. I'm looking for a proficient web developer to help enhance our website's Slingshot rental return process. - **Interactive Elements**: I require a chatbot for customer support, an interactive map for locating rental return locations, and an animated slider for showcasing our Slingshot models. These elements will make our site more dynamic and customer-friendly. - **UI Improvements**: I'm open to your suggestions on how to improve the user interface. This could involve optimizing the navigation menu, ensuring consistent branding elements throughout the website, and enhancing the overall visual design and aesthetics. - **SEO Optimization**: While I haven't provided specific requirements for SEO, any ...
I'm seeking experienced fabric artists with a knack for print design. The focus of the task will be creating unique designs using different materials like wool, silk, and cotton. The nature of the design task is not limited to a specific kind such as a poster, brochure or business card, but can aim to be multidimensional. The ideal candidate for this task should have: - An eye for detail and creating visually appealing print designs - Extensive experience with fabric art and print design - Mastery in working with various fabric types including cotton, silk, and wool - Exceptional skills in quilting, embroidery, and knitting Your creativity and artistic acumen will be appreciated and integral for the success of this project.
...and connect us with suppliers who can provide high volumes of wholesale international minutes. Key Requirements: - Sourcing: You should have experience in supplier sourcing specifically within the telecom industry. Previous experience in sourcing wholesale international minutes is a plus. - Telecom Knowledge: A good understanding of the telecom industry is essential for this task. This includes knowledge of the different types of telecom supplies and how they are sourced. - Regions of Interest: African countries (List of destination countries to be discussed upon meeting) - Negotiation Skills: You will be responsible for negotiating rates for international minutes so strong negotiation skills are a must. Your main task will be ...
Wir arbeiten mit All-Inkl als Hosting Provider zusammen. Im Laufe der Zeit haben sich Projekte ergeben und es wird Zeit einen grundlegende Einrichtung und Organisation so aufzusetzen, dass wir icht mehr den Überblick verlieren. Hierzu gehört: - Organisation der Accounts - Organisation der Domains - Organisation des Webspace - Organisation der Emailspaces, -adressen, usw - Einrichtung der grundlegenden Parameter und Settings - Einrichten der Accounts für Administration und Entwicklung - evtl. Aufbau eines Spaces für Entwicklungen (sofern es Sinn macht diese vom der späteren Webseite zu trennen). Aufbau einer Entwicklungsumgebung. evtl. Aufbau einer Testumgebung - Grundlegende Einrichtung von Wordpress damit alle verschiedenen Webseiten damit laufen könne...
...quarterly financials of 18 different organizations. You will be looking at the organization's income statements, balance sheets, and cash flow statements from the past year. Your expertise in financial analysis would be a big asset in this project. Key Tasks: - In-depth scrutiny of quarterly income statements - Detailed examination of balance sheets - Profound analysis of cash flow statements Please note, a comparative analysis among the organizations is not required for this project. Your focus should solely be on individual organization's financial health. Ideal Skills: - Experience in financial analysis and accounting - Detail-oriented with proven analytical skills - Ability to interpret complex financial data This job will require thorough an...
...enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Expe...
... 3. "Compliances and certifications that might be needed for a financial services startup" - explore main compliances for the US and European countries a fintech software startup should know about. The main goal of these articles is to educate our audience. Therefore, the content should be informative, engaging and able to simplify complex topics for an informed readership. Key job requirements: - Proven experience in creating engaging and educational blog content - Ability to write in a moderately technical style - Understanding of SEO best practices to drive organic traffic - Strong research skills to ensure factual accuracy - Familiarity with the topic of [Insert Topic Here] would be a great advantage, but not mandatory. Ideal candidates should also be ab...
I'm looking for an expert in Microsoft Power Apps to develop a canvas screen for me. The screen will enable the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently a...
I have a project that requires the development of a robust Android application. Key Requirements: - Development of a comprehensive Android application with 10 screens - Integration of 34 APIs to ensure seamless functionality - Design and implementation of a user-friendly UI/UX - Optimization for performance and security Designs, icons and api's will be provided by us Time 10 days
I'm in need of a virtual assistant to handle some of my workload. Your tasks will include recruitment and email management. Key Responsibilities: - Conducting recruitment tasks; this will involve posting job listings, conducting initial candidate screenings, and providing a shortlist of candidates for my review. - Managing my email account, this will involve responding to emails, flagging important ones, and organizing and filtering through them. I'm looking for an entry-level virtual assistant who can commit to working 10-20 hours a week. This will be an ongoing arrangement, so I need someone reliable and with great attention to detail. No prior experience is necessary, but you must be comfortable with using a computer and be able to ...
...skilled UI/UX designer to create a Hi-fidelity wireframe for my upcoming movie critics website. The site is set to serve movie enthusiasts of all ages, mainly adults, teenagers, and film enthusiasts. ### Project Scenario I aim to develop a website that functions as a MoviePageAsaService. This platform will enable users to publish their own movie critiques, reviews, and recommendations. The website will feature interfaces for registration and login specifically for critics. Once logged in, critics can create their own web pages within the main site, where they can upload movie posters along with comprehensive metadata about the movies. The homepage will showcase various top critics and their recommendations. General users can browse thr...
This is for the new profile view update and you will not be able to view it until the update finalizes and makes this the new normal profile view.
...Android. Key Features: - User Portal: This will be the main entry point for users. It should be user-friendly and intuitive. - Document Import: Users should be able to import documents into the application. - Document Merging: The app should have the capability to merge documents. - Text Processing: The application should be able to process text. File Formats: - The app should support the following file formats for document import: PDF, Word (docx), and text files. The ideal candidate for this job should have: - Proficient in both iOS and Android app development. - Experience with document processing and merging. - Knowledge of file format compatibility. Please provide samples of your previous work, especially if you have developed applications with similar fea...
I'm seeking a highly skilled Power BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level...
I'm in need of a professional who can help with my private limited company's annual compliance tasks. Key Tasks: - Filing Annual Financial Statements - Conducting an Audit - Updating Statutory Registers Key Requirements: A. Auditor Appointment & Filing of Form ADT - 01 (Auditor Appointment). B. Preparation & Filing of Form INC - 20A (Declaration of Commencement of Business). C. Assistance & Documents Preparation for Company's Current Bank Account. D. Preparation & Filing of Balance Sheet, P & L Accounts, Audit Report, and Director's Report. E. Preparation & Filing of Extract of Annual Returns & Financial Statements (Unlimited Transactions). F. Preparation & Filing of Annual Returns Form AOC - 04 (Financials Related Annual ...
I will create 14 football models
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project...
Primary tasks: Initially this is all to be done on a new Linux STAGING ONLY server. 1) Linux staging server setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need pa...
...WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. To qualify you must be full stack and work PROFICIENTLY with gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed an...
I'm in urgent need of an urban planner to assist me with a project related to the program 'Building Cities'. I need now help in the first part which is CITY FOUNDING i dont seem to relate between the CITY PLANINGm the CITY FOUNDING which is building the city hall and the Geography regions like the attached WOODLAND It should be simple.... check it out ... its urgent for today
Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Deliver...
I need a professional to prepare my income statement and balance sheet according to IFRS standards. My records are ready, and I only require a summary-level of detail. Ideal skills and experience include: - Proficiency in IFRS (International Financial Reporting Standards) - Proven track record in preparing financial statements, especially income statements and balance sheets - Detail-oriented and able to work with a high level of accuracy - Good communication skills to clarify any details for a summary-level reporting. This is a one-time project, but if successful, there may be more in the future.
I require an experienced accountant to prepare a set of financial documents for my company. Last 2 year Audited Financial statements for the previous 2 fiscal year-ends: Income Statement, Balance Sheet, Cash Flow Statement Interim Financial Statements (Balance Sheet, P&L, Cash Flow Statement) Financial statements for the most recent interim period: Income Statement, Balance Sheet, Cash Flow Statement Merchant Processing Statement
Se requiere un profesional que pueda diseñar un reporte en "SQL Server Report Builder". Este reporte, será modelo factura o pedido. Ya se cuenta con la consulta, y los parámetros de consulta (Fecha, desde - hasta), y también por número de documento (Desde - hasta).
Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto
...the driver's statement is captured, and based on that statement, part of the reason for the request is explained to the driver. ・Example: Memorizing the correlation between the driver's statement and part of the reason for the request. ・Example: If the driver's statement is similar to a recorded statement, a related explanation is presented to the driver. ・Example: Acquiring the cause of the request and downloading related information based on that cause. ・Example: This process is repeated until manual driving starts or until the switch to manual driving is indicated by the driver's statement. ・Example: Also has the capability to receive related information from a specific device, which is provided based on the driver's ...
...proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the basic complexity level spec...
...seeking a skilled web developer to create a responsive classified ad website with a blog section. Integration of the Stripe payment processor is a must. Key Details: - **Stripe Payment Integration**: You should be well-versed in integrating the Stripe payment processor into websites and ensuring smooth transaction processes. - **Blog Section**: The blog will focus on "Classified ad tips and tricks". Experience in setting up and maintaining engaging, informative blogs is important. - **State and City Pages**: I need pages for all states and relevant cities. Knowledge of SEO and how to structure these pages for optimal search engine visibility is a plus. - **Minimalist Design**: The website should be designed with a minimalist approach, emph...
I'm looking for a Python developer to help me set up a VONAGE API to send SMS messages. Key Project Details: - The main functio...functionality I need is to set up the ability to send SMS messages. - The application should be efficient, reliable, and easy to use. - I'm not yet sure if I need two-way communication or if the application will need to support sending messages to multiple countries. Skills and Experience: - Strong experience working with VONAGE API is a must. - Proficiency in Python, with a focus on SMS messaging. - Ability to create a reliable and user-friendly application. - Familiarity with creating two-way communication systems and international messaging support would be an advantage. If you're a Python developer wi...
I'm seeking a skilled and versatile bookkeeper to manage my accounts in QuickBooks. Key Responsibilities Include: - Daily entry of transactions - Financial statement preparation - Tax planning and filing Ideal Qualifications: - Proficiency in QuickBooks - Experience in managing both accounts payable and receivable - Strong understanding of tax planning - Excellent attention to detail - Previous experience working with a diverse range of transactions I value clear communication and a proactive approach to managing my finances. The role may be expanded in the future if the right candidate demonstrates a keen eye for financial strategy.
...straightforward with a total sum, without the need for categorization or a monthly breakdown. Ideal Skills: - Strong attention to detail: The invoice should be well laid out and error-free. - Graphic Design: Experience in adding logos and making documents look professional is a plus. - Familiarity with accounting and invoicing: Some knowledge of these areas will be beneficial for understanding the context and importance of the data being presented. Please note that I don't need any interactive elements such as clickable links or formulas. The main focus here is on turning the raw billing data into a clear, professional invoice. You're going to take a simple excel file with customer data and account numbers and create an easy to understand, simp...
I'm looking for programmers with solid experience in DeFi app development, particularly related to Liquidity pools, Yield farming, and Staking rewards. Key requirements for this project: - Creating a DeFi application that incorporates the above-mentioned features. A fully automated platform, that searches for highest return per transaction, and yet lowest or no risk opportunities in , liquidity pools , arbitrage of all sorts, staking, yield farming and any potential combination to achieve same goal. Ideally, this will be a platform similar to Krystal, but with the added features of above automation based on user request for each item of opportunity. Software must be able to find, on all existing platforms and exchanges these opportunities, ev...
...experience in graphic design, preferably for real estate - Strong portfolio of designs - Creativity and innovative ideas - Exceptional attention to detail -Familiarity with creating designs that generate leads and convey trust. Let's create a postcard that grabs attention and conveys our strong reputation in the market. We are looking for a postcard design for our home-buying business. I'm attaching several examples of our past postcards and several examples of current cards being used in our industry. The card needs to be clean, simple, and to the point... with an overall message of the following: Sell your house fast with no fees or repairs. We want to lean into the fact that we're local and have bought hundreds of houses in the Centra...
...project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names ...
I am seeking a vibrant, innovative brand strategist for a budding brand. The ideal candidate will understand how to speak to professionals in the 25-40 range successfully, recognizing their needs, tastes, and aspirations. Tasks: - Development of a brand strategy from scratch encompassing all key factors: the vision, mission, personality and the positioning statement. - In-depth competitive analysis to understand stand-out strategies in the current market. - Collaborative creation of a novel, targeted marketing plan. The suitable candidate should have: - Able track record of successful brand creation from zero. - Proficient understanding of marketing towards a professional demographic. - Sound knowledge of competitive analysis techniques.
I require an effective cloud-based construction software specifically designed with the features of project management, budget tracking, and document sharing. The primary function of this software will be to drive project efficiency by keeping all project details organized, deliver real-time budget oversight, and facilitate instant file exchanges. This tool is intended for use by my project managers and office administrators. Consequently, the ideal freelancer for this task should possess a strong proficiency in cloud-based software development, particularly those intended for construction project management. Your experience should also extend to designing user-friendly interfaces that cater to the needs of project management and administrative professionals. Web Appl...
I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency i...
I will help you getting a job on linkedin through the whole month i dily apply for a job on linkedin for you inshallah we will achieve this...
